PostGIS tutorial red hook neighborhood example

fixed_ish.geojson

redhook_current.geojson

{"features":[{"geometry":{"coordinates":[[[[-74.003674,40.6674714],[-74.0036751,40.6674649],[-74.003582,40.6673951],[-74.0035812,40.6673945],[-74.0035795,40.6673935],[-74.0035787,40.6673931],[-74.0033917,40.667303],[-74.0033904,40.6673025],[-74.0033878,40.6673017],[-74.0033864,40.6673013],[-74.0032684,40.6672812],[-74.0032678,40.6672811],[-74.0032666,40.667281],[-74.0032659,40.667281],[-74.0031789,40.6672771],[-74.0031779,40.6672771],[-74.0031757,40.6672772],[-74.0031747,40.6672774],[-74.0029286,40.6673193],[-74.0029277,40.6673195],[-74.002926,40.6673199],[-74.0029251,40.6673202],[-74.002832,40.6673542],[-74.0028309,40.6673547],[-74.0028286,40.6673559],[-74.0028275,40.6673566],[-74.0027726,40.6673946],[-74.0027708,40.6673962],[-74.0027677,40.6673996],[-74.0027664,40.6674015],[-74.0026725,40.6675735],[-74.0026724,40.6675737],[-74.0026721,40.6675742],[-74.002672,40.6675744],[-74.0022574,40.6684414],[-74.0025577,40.6678135],[-74.003674,40.6674714]]],[[[-74.0076316,40.6685182],[-74.0066059,40.668527],[-74.0066044,40.6685271],[-74.0066015,40.6685276],[-74.0066001,40.6685279],[-74.0065682,40.6685379],[-74.0065314,40.6685488],[-74.0065277,40.6685507],[-74.0065216,40.6685559],[-74.0065191,40.6685591],[-74.006135,40.6693432],[-74.0061349,40.6693433],[-74.0061348,40.6693435],[-74.0061348,40.6693436],[-74.0058512,40.6699599],[-74.0057175,40.6701913],[-74.0076316,40.6685182]]],[[[-74.0069899,40.6640717],[-74.0063862,40.6644942],[-74.0063865,40.6644993],[-74.0065117,40.6645692],[-74.0066672,40.6646688],[-74.0066675,40.6646689],[-74.0066681,40.6646693],[-74.0066684,40.6646694],[-74.0070653,40.6648875],[-74.0070669,40.6648882],[-74.00707,40.6648893],[-74.0070717,40.6648897],[-74.0071317,40.6648998],[-74.0071369,40.6648993],[-74.0071464,40.6648956],[-74.0071506,40.6648925],[-74.0072039,40.6648255],[-74.0072881,40.6647638],[-74.0073742,40.6647483],[-74.0074509,40.6647612],[-74.0075414,40.6648049],[-74.007542,40.6648052],[-74.0075433,40.6648057],[-74.0075439,40.6648059],[-74.0076408,40.6648371],[-74.0076442,40.6648376],[-74.007651,40.6648373],[-74.0076544,40.6648366],[-74.0076995,40.6648185],[-74.0077022,40.6648169],[-74.007707,40.6648128],[-74.0077091,40.6648104],[-74.007747,40.6647485],[-74.0077478,40.6647468],[-74.0077492,40.6647432],[-74.0077497,40.6647414],[-74.0077607,40.6646753],[-74.0077608,40.6646743],[-74.007761,40.6646721],[-74.007761,40.664671],[-74.0077569,40.6645921],[-74.0077567,40.6645904],[-74.007756,40.6645871],[-74.0077555,40.6645855],[-74.0077355,40.6645364],[-74.0077346,40.6645346],[-74.0077323,40.6645312],[-74.0077309,40.6645296],[-74.0076919,40.6644917],[-74.007691,40.6644909],[-74.0076891,40.6644895],[-74.0076881,40.6644888],[-74.0071794,40.6641897],[-74.0069899,40.6640717]]],[[[-74.009874,40.6620534],[-74.0083185,40.663142],[-74.0083187,40.6631469],[-74.0086738,40.6633572],[-74.0086762,40.6633582],[-74.0086813,40.6633596],[-74.008684,40.66336],[-74.008754,40.66336],[-74.0087545,40.66336],[-74.0087556,40.6633599],[-74.0087561,40.6633599],[-74.009026,40.6633317],[-74.0090265,40.6633316],[-74.0090275,40.6633315],[-74.0090281,40.6633314],[-74.0094951,40.6632326],[-74.0094956,40.6632325],[-74.0094965,40.6632323],[-74.009497,40.6632321],[-74.00976,40.663149],[-74.0097607,40.6631488],[-74.0097621,40.6631482],[-74.0097627,40.6631479],[-74.0099537,40.6630549],[-74.0099547,40.6630543],[-74.0099565,40.6630531],[-74.0099574,40.6630525],[-74.0100785,40.6629556],[-74.0100789,40.6629552],[-74.0100798,40.6629544],[-74.0100802,40.662954],[-74.0102572,40.662774],[-74.0102578,40.6627734],[-74.0102588,40.6627722],[-74.0102593,40.6627716],[-74.0104282,40.6625354],[-74.0104299,40.6625313],[-74.0104315,40.6625228],[-74.0104312,40.6625184],[-74.0103972,40.6623957],[-74.0103956,40.6623924],[-74.0103914,40.6623867],[-74.0103887,40.6623842],[-74.009874,40.6620534]]],[[[-74.0126927,40.6600481],[-74.012704,40.6600453],[-74.0127094,40.6600602],[-74.0127057,40.6600718],[-74.0110624,40.6612218],[-74.0110626,40.6612266],[-74.0126955,40.6622191],[-74.0126971,40.6622199],[-74.0127003,40.6622212],[-74.012702,40.6622217],[-74.0128061,40.6622426],[-74.0128095,40.6622427],[-74.0128162,40.6622417],[-74.0128195,40.6622406],[-74.0134535,40.6618996],[-74.0134537,40.6618995],[-74.0134541,40.6618993],[-74.0134542,40.6618992],[-74.0136647,40.6617744],[-74.0144983,40.6613317],[-74.0144987,40.6613315],[-74.0144994,40.6613311],[-74.0144997,40.6613309],[-74.0145698,40.6612858],[-74.014573,40.6612825],[-74.0145776,40.6612747],[-74.014579,40.6612703],[-74.014582,40.6612254],[-74.0145818,40.6612226],[-74.0145806,40.6612173],[-74.0145797,40.6612147],[-74.0145416,40.6611426],[-74.0145399,40.6611403],[-74.0145359,40.6611362],[-74.0145336,40.6611344],[-74.014132,40.6609147],[-74.0127065,40.6600447],[-74.0126927,40.6600481]]],[[[-74.0123678,40.6591222],[-74.0123713,40.659122],[-74.01244,40.6593127],[-74.0136234,40.660049],[-74.0136254,40.6600499],[-74.0136297,40.6600514],[-74.0136319,40.6600519],[-74.0136699,40.6600559],[-74.0136745,40.6600553],[-74.0136829,40.6600521],[-74.0136867,40.6600495],[-74.0137218,40.6600115],[-74.013724,40.6600076],[-74.0137265,40.6599991],[-74.0137268,40.6599946],[-74.0137167,40.6599356],[-74.0137151,40.6599316],[-74.0137104,40.6599247],[-74.0137073,40.6599218],[-74.0123793,40.6591214],[-74.0123678,40.6591222]]],[[[-74.0142124,40.6577698],[-74.0128522,40.6587101],[-74.014165,40.6595241],[-74.014165,40.6595435],[-74.014119,40.6595957],[-74.0140021,40.6596947],[-74.0140008,40.659696],[-74.0139984,40.6596989],[-74.0139974,40.6597005],[-74.0139694,40.6597524],[-74.0139683,40.6597562],[-74.0139675,40.6597639],[-74.0139679,40.6597678],[-74.0139818,40.6598129],[-74.0139831,40.6598156],[-74.0139866,40.6598206],[-74.0139886,40.6598228],[-74.0140617,40.6598798],[-74.0140622,40.6598801],[-74.0140631,40.6598807],[-74.0140635,40.659881],[-74.0144945,40.6601471],[-74.0145052,40.660147],[-74.0145204,40.6601371],[-74.0145249,40.6601275],[-74.0142173,40.657772],[-74.0142124,40.6577698]]],[[[-74.0137859,40.6710325],[-74.0137854,40.6710207],[-74.0144649,40.671406],[-74.0151742,40.6707831],[-74.0151775,40.6707767],[-74.0151791,40.6707634],[-74.0151773,40.6707565],[-74.0151334,40.6706944],[-74.0151316,40.6706925],[-74.0151275,40.6706891],[-74.0151252,40.6706877],[-74.0150852,40.6706698],[-74.0150835,40.6706692],[-74.01508,40.6706684],[-74.0150782,40.6706681],[-74.0150272,40.6706651],[-74.015024,40.6706654],[-74.0150179,40.6706671],[-74.015015,40.6706684],[-74.014961,40.6707043],[-74.0149605,40.6707046],[-74.0149594,40.6707054],[-74.0149589,40.6707058],[-74.014405,40.671189],[-74.0143317,40.6712352],[-74.0142579,40.6712669],[-74.0141031,40.6711868],[-74.0140371,40.6710785],[-74.0140352,40.6710761],[-74.0140306,40.6710722],[-74.014028,40.6710705],[-74.013886,40.6710087],[-74.0138838,40.671008],[-74.0138793,40.6710072],[-74.013877,40.671007],[-74.0137969,40.6710111],[-74.0137942,40.6710116],[-74.013789,40.6710133],[-74.0137866,40.6710146],[-74.0137852,40.6710156],[-74.0137859,40.6710325]]],[[[-74.0174208,40.6594482],[-74.0174159,40.6594528],[-74.0174053,40.6594547],[-74.0160921,40.6589208],[-74.0160897,40.6589194],[-74.0144269,40.6576215],[-74.0142816,40.6577219],[-74.0141648,40.6575186],[-74.0153247,40.659537],[-74.0153285,40.6595408],[-74.0153376,40.6595458],[-74.0153428,40.659547],[-74.0174108,40.6594659],[-74.0174181,40.6594623],[-74.0174202,40.6594598],[-74.0174211,40.6594483],[-74.0174208,40.6594482]]],[[[-74.0163289,40.6724629],[-74.0160924,40.6726603],[-74.0163289,40.6724629],[-74.0163289,40.6724629]]],[[[-74.0194748,40.6575284],[-74.0189383,40.6580298],[-74.0189362,40.6580181],[-74.0189392,40.6580347],[-74.0192414,40.6581585],[-74.0192435,40.6581591],[-74.0192476,40.6581599],[-74.0192497,40.65816],[-74.0193327,40.658157],[-74.019335,40.6581566],[-74.0193394,40.6581554],[-74.0193415,40.6581546],[-74.0194245,40.6581097],[-74.0194256,40.658109],[-74.0194276,40.6581075],[-74.0194286,40.6581068],[-74.0195226,40.6580197],[-74.0195237,40.6580185],[-74.0195258,40.6580158],[-74.0195267,40.6580144],[-74.0195847,40.6579041],[-74.0195854,40.6579024],[-74.0195865,40.657899],[-74.0195869,40.6578973],[-74.0196008,40.6577864],[-74.0196009,40.6577854],[-74.0196009,40.6577832],[-74.0196008,40.6577821],[-74.019594,40.6577092],[-74.0195937,40.6577077],[-74.019593,40.6577048],[-74.0195925,40.6577034],[-74.0195655,40.6576382],[-74.019565,40.6576371],[-74.0195638,40.6576349],[-74.0195631,40.6576339],[-74.019514,40.6575678],[-74.0195135,40.6575673],[-74.0195126,40.6575662],[-74.0195121,40.6575656],[-74.0194748,40.6575284]]],[[[-74.0204316,40.6566341],[-74.0201368,40.6569097],[-74.0201371,40.656913],[-74.0205025,40.657137],[-74.0205042,40.6571378],[-74.0205077,40.6571391],[-74.0205096,40.6571396],[-74.0206066,40.6571566],[-74.0206096,40.6571566],[-74.0206154,40.6571559],[-74.0206183,40.6571551],[-74.0206801,40.6571273],[-74.0206809,40.6571269],[-74.0206824,40.657126],[-74.0206832,40.6571256],[-74.0207492,40.6570805],[-74.0207512,40.6570787],[-74.0207546,40.6570747],[-74.020756,40.6570725],[-74.020784,40.6570133],[-74.0207846,40.6570118],[-74.0207855,40.6570086],[-74.0207858,40.657007],[-74.0207919,40.6569521],[-74.0207919,40.6569499],[-74.0207914,40.6569455],[-74.0207909,40.6569433],[-74.0207739,40.6568953],[-74.0207731,40.6568935],[-74.020771,40.6568901],[-74.0207698,40.6568885],[-74.0206937,40.6568055],[-74.0206928,40.6568046],[-74.0206909,40.656803],[-74.0206899,40.6568023],[-74.0204316,40.6566341]]],[[[-74.0222789,40.6549035],[-74.0222815,40.654905],[-74.0220462,40.655125],[-74.0223236,40.655294],[-74.0223241,40.6552943],[-74.0223251,40.6552948],[-74.0223256,40.655295],[-74.0225335,40.6553921],[-74.0225355,40.6553928],[-74.0225398,40.6553937],[-74.0225419,40.655394],[-74.022611,40.655394],[-74.0226144,40.6553934],[-74.0226209,40.655391],[-74.0226239,40.6553892],[-74.0226688,40.6553512],[-74.0226698,40.6553503],[-74.0226716,40.6553483],[-74.0226724,40.6553473],[-74.0227104,40.6552921],[-74.0227115,40.6552903],[-74.0227131,40.6552863],[-74.0227137,40.6552842],[-74.0227247,40.6552214],[-74.0227248,40.6552184],[-74.0227241,40.6552125],[-74.0227232,40.6552096],[-74.0226983,40.6551547],[-74.0226966,40.6551521],[-74.0226926,40.6551476],[-74.0226902,40.6551457],[-74.0222789,40.6549035]]],[[[-74.0232264,40.6540218],[-74.0230062,40.6542277],[-74.0234458,40.6544901],[-74.0234475,40.6544909],[-74.0234512,40.6544922],[-74.023453,40.6544927],[-74.0235189,40.6545028],[-74.0235218,40.6545028],[-74.0235274,40.654502],[-74.0235302,40.6545012],[-74.0235922,40.6544732],[-74.0235937,40.6544724],[-74.0235966,40.6544704],[-74.0235979,40.6544693],[-74.023633,40.6544351],[-74.0236341,40.6544337],[-74.0236362,40.6544308],[-74.0236371,40.6544293],[-74.0236581,40.6543845],[-74.023659,40.6543812],[-74.0236596,40.6543743],[-74.0236593,40.6543709],[-74.0236454,40.6543189],[-74.0236447,40.654317],[-74.0236429,40.6543135],[-74.0236418,40.6543118],[-74.0236038,40.6542627],[-74.0236026,40.6542614],[-74.0236001,40.6542591],[-74.0235987,40.6542581],[-74.0232264,40.6540218]]],[[[-74.0241247,40.6531822],[-74.0238966,40.6533954],[-74.0238952,40.6533831],[-74.023897,40.653399],[-74.0241489,40.6535453],[-74.0241493,40.6535454],[-74.02415,40.6535458],[-74.0241503,40.653546],[-74.0243233,40.653629],[-74.0243254,40.6536297],[-74.0243297,40.6536307],[-74.024332,40.6536309],[-74.024419,40.6536309],[-74.0244216,40.6536306],[-74.0244266,40.6536292],[-74.024429,40.6536282],[-74.0244771,40.6536002],[-74.0244796,40.6535982],[-74.0244837,40.6535935],[-74.0244854,40.6535909],[-74.0245134,40.653526],[-74.024514,40.6535241],[-74.0245149,40.6535201],[-74.0245151,40.6535181],[-74.0245151,40.653476],[-74.0245147,40.6534732],[-74.0245132,40.6534679],[-74.024512,40.6534654],[-74.0244841,40.6534205],[-74.0244827,40.6534188],[-74.0244797,40.6534157],[-74.0244781,40.6534143],[-74.0241247,40.6531822]]],[[[-74.0342209,40.6437454],[-74.0337767,40.6441607],[-74.033777,40.644164],[-74.0339996,40.6443009],[-74.0340018,40.6443019],[-74.0340064,40.6443034],[-74.0340088,40.6443039],[-74.0340608,40.644307],[-74.0340627,40.644307],[-74.0340664,40.6443065],[-74.0340683,40.6443061],[-74.0341293,40.644286],[-74.0341313,40.644285],[-74.0341351,40.6442828],[-74.0341368,40.6442814],[-74.0345118,40.6439235],[-74.0345133,40.6439218],[-74.0345158,40.643918],[-74.0345168,40.643916],[-74.0345347,40.6438679],[-74.0345343,40.6438601],[-74.034528,40.643847],[-74.0345221,40.6438419],[-74.0342209,40.6437454]]]],"type":"MultiPolygon"},"id":"5fcc9fe3-7951-4811-b0bc-7e57a7171254","properties":{"boroname":"Brooklyn","name":"Red Hook"},"type":"Feature"}],"type":"FeatureCollection"}