trees
5,599 rows where qSpecies_id = 38 sorted by Zip Codes
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▼ | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 114451 | 127527 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 401 Post St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6010050.60455 | 2115065.82675 | 37.7881343591479 | -122.409034556825 | (37.7881343591479, -122.409034556825) | 5 | 1 | 10 | 28852 | 36 | |||
| 115627 | 224772 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 314 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004894.58585 | 2110051.74119 | 37.7740767369926 | -122.426516335083 | (37.7740767369926, -122.426516335083) | 7 | 9 | 11 | 28852 | 10 | |||
| 116273 | 224764 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 301 Lily St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005023.57215 | 2110045.73192 | 37.7740675279259 | -122.426069720964 | (37.7740675279259, -122.426069720964) | 7 | 9 | 11 | 28852 | 10 | |||
| 116922 | 127510 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 233 Geary St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6010663.62591 | 2114810.0943 | 37.7874665001379 | -122.406895566999 | (37.7874665001379, -122.406895566999) | 5 | 1 | 10 | 28852 | 6 | |||
| 117717 | 127582 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 515 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6008808.58987 | 2114201.47158 | 37.7856913948804 | -122.413270581268 | (37.7856913948804, -122.413270581268) | 7 | 10 | 9 | 28852 | 36 | |||
| 118107 | 117338 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 364 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 24 | 6x7 | 6006121.81566 | 2111101.29627 | 37.7770278622883 | -122.422345715582 | (37.7770278622883, -122.422345715582) | 7 | 9 | 11 | 28852 | 10 | ||
| 119357 | 95273 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 623 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004855.86616 | 2110874.93767 | 37.776334844721 | -122.426708906913 | (37.776334844721, -122.426708906913) | 7 | 9 | 11 | 28852 | 10 | |||
| 119470 | 6376 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 311X Elm St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006100.46192 | 2112621.53299 | 37.7812008577844 | -122.422527635837 | (37.7812008577844, -122.422527635837) | 7 | 9 | 11 | 28852 | 41 | |||
| 120170 | 127514 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 335 Powell St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6010238.1387 | 2114901.34541 | 37.7876932363033 | -122.408374111795 | (37.7876932363033, -122.408374111795) | 5 | 1 | 10 | 28852 | 36 | |||
| 121663 | 16901 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 416 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004964.98155 | 2110242.86511 | 37.7746054960847 | -122.426286434179 | (37.7746054960847, -122.426286434179) | 7 | 9 | 11 | 28852 | 10 | |||
| 122147 | 127539 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 170 O'Farrell St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6010502.55628 | 2114485.19181 | 37.7865653812451 | -122.407429923462 | (37.7865653812451, -122.407429923462) | 5 | 10 | 10 | 28852 | 6 | |||
| 122377 | 127543 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 222 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6009907.0661 | 2114131.39033 | 37.7855605786008 | -122.409465203482 | (37.7855605786008, -122.409465203482) | 14 | 10 | 9 | 28852 | 36 | |||
| 122603 | 126640 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 619 Hayes St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6004870.87553 | 2110876.49293 | 37.776339963658 | -122.426657096074 | (37.776339963658, -122.426657096074) | 7 | 9 | 11 | 28852 | 10 | |||
| 122806 | 127568 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 80 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6010039.06132 | 2113723.16922 | 37.784447095597 | -122.408979723334 | (37.784447095597, -122.408979723334) | 14 | 10 | 10 | 28852 | 36 | |||
| 124380 | 127550 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 155 Cyril Magnin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6010052.66602 | 2114341.92983 | 37.7861468268677 | -122.408976328411 | (37.7861468268677, -122.408976328411) | 14 | 10 | 9 | 28852 | 36 | |||
| 124467 | 59675 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 370 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1981 12:00:00 AM | 28 | 6x6 | Permit Number 19101 | 6006098.88187 | 2111098.2635 | 37.7770182413384 | -122.422424835258 | (37.7770182413384, -122.422424835258) | 7 | 9 | 11 | 28852 | 10 | |
| 125042 | 117342 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 372 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 5x5 | 6006002.37351 | 2111082.14278 | 37.776968533116 | -122.42275754215 | (37.776968533116, -122.42275754215) | 7 | 9 | 11 | 28852 | 10 | |||
| 125486 | 9692 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 330 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005977.63731 | 2110934.31764 | 37.7765612454456 | -122.422832604057 | (37.7765612454456, -122.422832604057) | 7 | 9 | 11 | 28852 | 10 | |||
| 127024 | 127540 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 188 O'Farrell St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6010477.4946 | 2114483.25996 | 37.7865586740793 | -122.407516494887 | (37.7865586740793, -122.407516494887) | 5 | 10 | 10 | 28852 | 6 | |||
| 128508 | 127512 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 233 Geary St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6010697.7596 | 2114813.07787 | 37.7874766022217 | -122.406777681142 | (37.7874766022217, -122.406777681142) | 5 | 1 | 10 | 28852 | 6 | |||
| 129377 | 127664 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 330 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6005973.6913 | 2110970.60635 | 37.7766606628006 | -122.422848834101 | (37.7766606628006, -122.422848834101) | 7 | 9 | 11 | 28852 | 10 | |||
| 129705 | 226530 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 498 Oak St | 1 | : | Tree | DPW 1 | 16 | Width 4ft | 6004664.90455 | 2110206.95803 | 37.7744899376984 | -122.427321901889 | (37.7744899376984, -122.427321901889) | 7 | 9 | 11 | 28852 | 10 | |||
| 132175 | 127563 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 55 Cyril Magnin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6010151.15271 | 2113926.57896 | 37.7850118887296 | -122.408606278052 | (37.7850118887296, -122.408606278052) | 14 | 10 | 10 | 28852 | 36 | |||
| 132316 | 127523 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 441 Mason St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6009738.46846 | 2114958.1431 | 37.7878211954387 | -122.410106893143 | (37.7878211954387, -122.410106893143) | 5 | 1 | 10 | 28852 | 36 | |||
| 134055 | 127557 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 181 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6009993.06277 | 2114017.74936 | 37.7852533656998 | -122.40915965701 | (37.7852533656998, -122.40915965701) | 14 | 10 | 10 | 28852 | 36 | |||
| 134431 | 127558 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 181 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010020.60713 | 2114021.09614 | 37.7852640982121 | -122.409064597778 | (37.7852640982121, -122.409064597778) | 14 | 10 | 10 | 28852 | 36 | |||
| 134934 | 127647 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 355 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6006102.32245 | 2111395.69556 | 37.7778351117328 | -122.42243407218 | (37.7778351117328, -122.42243407218) | 7 | 9 | 11 | 28852 | 10 | |||
| 135802 | 16918 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 500 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6004517.01501 | 2110184.28152 | 37.7744193085393 | -122.427831864273 | (37.7744193085393, -122.427831864273) | 7 | 9 | 11 | 28852 | 10 | |||
| 136988 | 31339 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 365 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 8 | Permit Number 34952 | 6006078.70022 | 2111390.77564 | 37.7778202702316 | -122.42251544013 | (37.7778202702316, -122.42251544013) | 7 | 9 | 11 | 28852 | 10 | |
| 138221 | 127668 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 330 Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005970.45175 | 2111012.7201 | 37.7767761141607 | -122.422863034416 | (37.7767761141607, -122.422863034416) | 7 | 9 | 11 | 28852 | 10 | |||
| 139309 | 127544 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 222 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6009889.43984 | 2114253.40718 | 37.7858946200947 | -122.4095348002 | (37.7858946200947, -122.4095348002) | 14 | 10 | 9 | 28852 | 36 | |||
| 141239 | 127666 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 330 Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6005970.65388 | 2110994.02831 | 37.776724802442 | -122.422861006441 | (37.776724802442, -122.422861006441) | 7 | 9 | 11 | 28852 | 10 | |||
| 141947 | 127659 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 379 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6006058.46727 | 2111043.61492 | 37.7768659096591 | -122.422560757875 | (37.7768659096591, -122.422560757875) | 7 | 9 | 11 | 28852 | 10 | |||
| 144311 | 127628 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 11 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008220.97264 | 2111917.42638 | 37.7793869485842 | -122.415141841128 | (37.7793869485842, -122.415141841128) | 7 | 10 | 9 | 28852 | 36 | |||
| 144462 | 225319 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Oak St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6006215.02853 | 2110426.44989 | 37.7751801547778 | -122.421975311837 | (37.7751801547778, -122.421975311837) | 7 | 9 | 11 | 28852 | 10 | |||
| 145022 | 103110 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 300 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010569.23716 | 2115194.23983 | 37.7885159900773 | -122.407249224481 | (37.7885159900773, -122.407249224481) | 5 | 1 | 10 | 28852 | 6 | |||
| 146456 | 127502 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 535 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009271.45916 | 2114824.1374 | 37.7874270612549 | -122.411713192008 | (37.7874270612549, -122.411713192008) | 5 | 1 | 10 | 28852 | 36 | |||
| 149158 | 127549 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 222 Mason St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009877.13299 | 2114323.52529 | 37.7860864580682 | -122.409582329368 | (37.7860864580682, -122.409582329368) | 14 | 10 | 9 | 28852 | 36 | |||
| 150132 | 127644 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 30 Grove St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6007939.9704 | 2111706.64993 | 37.7787924112801 | -122.416099017452 | (37.7787924112801, -122.416099017452) | 7 | 10 | 9 | 28852 | 36 | |||
| 150705 | 127509 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 233 Geary St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6010607.64382 | 2114802.65029 | 37.7874429279912 | -122.407088729677 | (37.7874429279912, -122.407088729677) | 5 | 1 | 10 | 28852 | 6 | |||
| 151564 | 7710 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006505.57437 | 2110325.13763 | 37.774918357632 | -122.420963052012 | (37.774918357632, -122.420963052012) | 7 | 9 | 11 | 28852 | 10 | |||
| 153785 | 127624 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 300 Elm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 4ft | 6006131.24872 | 2112645.91045 | 37.7812695290991 | -122.422422861228 | (37.7812695290991, -122.422422861228) | 7 | 9 | 11 | 28852 | 41 | |||
| 153881 | 127645 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 30 Grove St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6007914.85136 | 2111702.90673 | 37.7787807209819 | -122.416185649145 | (37.7787807209819, -122.416185649145) | 7 | 10 | 9 | 28852 | 36 | |||
| 155002 | 127562 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 55 Cyril Magnin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6010147.26687 | 2113952.55315 | 37.785082990044 | -122.408621554848 | (37.785082990044, -122.408621554848) | 14 | 10 | 10 | 28852 | 36 | |||
| 155677 | 127669 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 330 Gough St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6005967.66445 | 2111019.78524 | 37.7767953560506 | -122.422873178776 | (37.7767953560506, -122.422873178776) | 7 | 9 | 11 | 28852 | 10 | |||
| 155859 | 16916 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 484 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6004686.86681 | 2110208.72077 | 37.7744960198036 | -122.427246055766 | (37.7744960198036, -122.427246055766) | 7 | 9 | 11 | 28852 | 10 | |||
| 155961 | 127665 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 330 Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6005972.79495 | 2110984.05651 | 37.7766975431042 | -122.422852890971 | (37.7766975431042, -122.422852890971) | 7 | 9 | 11 | 28852 | 10 | |||
| 157721 | 127537 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 170 O'Farrell St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6010564.13877 | 2114497.61685 | 37.7866029441058 | -122.407217738318 | (37.7866029441058, -122.407217738318) | 5 | 10 | 10 | 28852 | 6 | |||
| 158797 | 9691 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 330 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6005982.01492 | 2110919.04398 | 37.7765195546743 | -122.422816374886 | (37.7765195546743, -122.422816374886) | 7 | 9 | 11 | 28852 | 10 | |||
| 159915 | 127640 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 30 Grove St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6008091.78134 | 2111723.00522 | 37.7788458535004 | -122.415575000508 | (37.7788458535004, -122.415575000508) | 7 | 10 | 9 | 28852 | 36 | |||
| 160163 | 127547 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 222 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6009882.08932 | 2114301.92664 | 37.7860274310619 | -122.409563656758 | (37.7860274310619, -122.409563656758) | 14 | 10 | 9 | 28852 | 36 | |||
| 160855 | 127639 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 30 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6008159.77461 | 2111732.56142 | 37.7788759142302 | -122.41534046089 | (37.7788759142302, -122.41534046089) | 7 | 10 | 9 | 28852 | 36 | |||
| 160898 | 127630 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 11 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008225.04804 | 2111877.80833 | 37.7792783959164 | -122.415124937459 | (37.7792783959164, -122.415124937459) | 7 | 10 | 9 | 28852 | 36 | |||
| 162256 | 127567 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 80 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6010117.23109 | 2113730.85779 | 37.7844725850885 | -122.408709824196 | (37.7844725850885, -122.408709824196) | 14 | 10 | 10 | 28852 | 36 | |||
| 163783 | 127478 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 524 Post St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6009497.51354 | 2115036.25724 | 37.7880221696405 | -122.410946074821 | (37.7880221696405, -122.410946074821) | 5 | 1 | 10 | 28852 | 21 | |||
| 164272 | 26843 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | Permit Number 775213 | 6006968.35618 | 2110982.6622 | 37.7767498377733 | -122.419408844544 | (37.7767498377733, -122.419408844544) | 7 | 9 | 9 | 28852 | 36 | ||
| 165190 | 68431 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 336 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1993 12:00:00 AM | 18 | Permit Number 32282 | 6006252.34757 | 2111117.88655 | 37.7770807774889 | -122.421895343221 | (37.7770807774889, -122.421895343221) | 7 | 9 | 11 | 28852 | 10 | ||
| 165192 | 127653 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 290 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6006015.38156 | 2110898.03666 | 37.7764637562444 | -122.422699456724 | (37.7764637562444, -122.422699456724) | 7 | 9 | 11 | 28852 | 10 | |||
| 165236 | 127534 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 101 O'Farrell St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 3ft | 6010622.18881 | 2114505.22793 | 37.7866270909228 | -122.407017435006 | (37.7866270909228, -122.407017435006) | 5 | 10 | 10 | 28852 | 6 | |||
| 165352 | 224765 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 301 Lily St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005040.4516 | 2110047.62054 | 37.7740736676002 | -122.426011466464 | (37.7740736676002, -122.426011466464) | 7 | 9 | 11 | 28852 | 10 | |||
| 166349 | 103107 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 300 Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010612.4895 | 2115201.53409 | 37.7885384389361 | -122.4071000917 | (37.7885384389361, -122.4071000917) | 5 | 1 | 10 | 28852 | 6 | |||
| 173932 | 9693 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 414 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2012 12:00:00 AM | 3 | 3X3 | 6005939.70475 | 2111200.22801 | 37.7772892304617 | -122.422982727867 | (37.7772892304617, -122.422982727867) | 7 | 9 | 11 | 28852 | 10 | ||
| 174384 | 226531 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 101 Rose St | 2 | : | Tree | Private 2 | 14 | Width 3ft | 6006054.67941 | 2109842.32177 | 37.7735672350795 | -122.42248848118 | (37.7735672350795, -122.42248848118) | 7 | 9 | 11 | 28852 | 10 | |||
| 174536 | 127636 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 11 Hyde St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6008243.47914 | 2111763.69267 | 37.7789660973341 | -122.415053096938 | (37.7789660973341, -122.415053096938) | 7 | 10 | 9 | 28852 | 36 | |||
| 174566 | 127518 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 330 Geary St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6010076.21551 | 2114771.78953 | 37.7873284380105 | -122.408925192945 | (37.7873284380105, -122.408925192945) | 5 | 1 | 10 | 28852 | 36 | |||
| 174886 | 6377 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 311X Elm St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006125.71755 | 2112628.3698 | 37.7812210547395 | -122.422440749665 | (37.7812210547395, -122.422440749665) | 7 | 9 | 11 | 28852 | 41 | |||
| 177276 | 103108 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 300 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010599.7189 | 2115199.34149 | 37.7885317039092 | -122.407144121614 | (37.7885317039092, -122.407144121614) | 5 | 1 | 10 | 28852 | 6 | |||
| 179510 | 127570 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 80 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6009984.93294 | 2113715.47902 | 37.7844229478935 | -122.409166446894 | (37.7844229478935, -122.409166446894) | 14 | 10 | 10 | 28852 | 36 | |||
| 179867 | 127520 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 330 Geary St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6010050.03669 | 2114776.41152 | 37.7873396624443 | -122.409016092817 | (37.7873396624443, -122.409016092817) | 5 | 1 | 10 | 28852 | 36 | |||
| 179903 | 127633 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 11 Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008237.75888 | 2111812.46776 | 37.7790997006286 | -122.41507633902 | (37.7790997006286, -122.41507633902) | 7 | 10 | 9 | 28852 | 36 | |||
| 181904 | 33652 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 284 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 17 | Permit Number 37742 | 6006070.94642 | 2110907.70548 | 37.7764934392605 | -122.422507928998 | (37.7764934392605, -122.422507928998) | 7 | 9 | 11 | 28852 | 10 | ||
| 183352 | 249393 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 320 Turk St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6008405.64882 | 2113154.88185 | 37.7827950814738 | -122.414590558504 | (37.7827950814738, -122.414590558504) | 7 | 10 | 9 | 28852 | 36 | |||
| 183448 | 117340 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 372 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | 5x5 | 6006058.24228 | 2111089.75465 | 37.7769925854829 | -122.422564815625 | (37.7769925854829, -122.422564815625) | 7 | 9 | 11 | 28852 | 10 | |||
| 184732 | 127648 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 301 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6006233.71312 | 2111414.97743 | 37.7778954661494 | -122.421980915483 | (37.7778954661494, -122.421980915483) | 7 | 9 | 11 | 28852 | 10 | |||
| 187805 | 127532 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 120 O'Farrell St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 3ft | 6010687.11448 | 2114513.18802 | 37.7866525804096 | -122.406793368031 | (37.7866525804096, -122.406793368031) | 5 | 10 | 10 | 28852 | 6 | |||
| 188121 | 127505 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 281 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2018 12:00:00 AM | 3 | Width 4ft | 6010424.38139 | 2114774.09109 | 37.7873542539455 | -122.407720768708 | (37.7873542539455, -122.407720768708) | 5 | 1 | 10 | 28852 | 6 | ||
| 188495 | 249414 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 640 Turk St | 3 | : | Tree | Private 2 | 14 | Width 4ft | 6006875.43405 | 2112939.59497 | 37.7821178676847 | -122.419869186806 | (37.7821178676847, -122.419869186806) | 7 | 9 | 9 | 28852 | 36 | |||
| 188539 | 127530 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 120 O'Farrell St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6010757.93544 | 2114521.51649 | 37.7866794107706 | -122.406548930483 | (37.7866794107706, -122.406548930483) | 5 | 10 | 10 | 28852 | 6 | |||
| 189967 | 127564 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 55 Cyril Magnin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6010154.07785 | 2113901.60107 | 37.7849434692107 | -122.408594395321 | (37.7849434692107, -122.408594395321) | 14 | 10 | 10 | 28852 | 36 | |||
| 190400 | 127511 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 233 Geary St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6010684.11833 | 2114808.45009 | 37.7874631321724 | -122.406824551121 | (37.7874631321724, -122.406824551121) | 5 | 1 | 10 | 28852 | 6 | |||
| 191114 | 127526 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 535 Post St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6009680.02816 | 2115011.25309 | 37.7879637469644 | -122.410312837863 | (37.7879637469644, -122.410312837863) | 5 | 1 | 10 | 28852 | 36 | |||
| 191982 | 127503 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 281 Geary St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6010396.37791 | 2114769.7566 | 37.7873407848018 | -122.407817349602 | (37.7873407848018, -122.407817349602) | 5 | 1 | 10 | 28852 | 6 | |||
| 192288 | 127515 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 335 Powell St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6010244.58304 | 2114855.01998 | 37.7875663986225 | -122.408348546747 | (37.7875663986225, -122.408348546747) | 5 | 1 | 10 | 28852 | 36 | |||
| 192302 | 127504 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 281 Geary St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6010412.84164 | 2114771.87381 | 37.7873475198242 | -122.407760537619 | (37.7873475198242, -122.407760537619) | 5 | 1 | 10 | 28852 | 6 | |||
| 192850 | 117339 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 372 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 5x5 | 6006074.72787 | 2111092.91986 | 37.77700220641 | -122.422508011759 | (37.77700220641, -122.422508011759) | 7 | 9 | 11 | 28852 | 10 | |||
| 193281 | 255776 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 281 Geary St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | Width 4ft | 6010453.10569 | 2114773.50548 | 37.7873542539382 | -122.407621346845 | (37.7873542539382, -122.407621346845) | 5 | 1 | 10 | 28852 | 6 | ||||
| 193995 | 127629 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 11 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008224.12562 | 2111892.42462 | 37.7793184769176 | -122.415129163391 | (37.7793184769176, -122.415129163391) | 7 | 10 | 9 | 28852 | 36 | |||
| 648 | 189633 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 10 | : | Tree | Private 2 | 10 | Width 3ft | 6007281.55408 | 2110475.16176 | 37.775373998252 | -122.418289406239 | (37.775373998252, -122.418289406239) | 8 | 2 | 9 | 28853 | 34 | |||
| 649 | 189627 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 4 | : | Tree | Private 2 | 16 | Width 3ft | 6007528.52851 | 2110215.72509 | 37.7746755460784 | -122.417416671761 | (37.7746755460784, -122.417416671761) | 8 | 2 | 9 | 28853 | 34 | |||
| 992 | 192119 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 807 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 22 | Width 4ft | 6010836.94593 | 2113119.25584 | 37.782833554469 | -122.406176740686 | (37.782833554469, -122.406176740686) | 12 | 2 | 9 | 28853 | 34 | |||
| 1042 | 189625 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 2 | : | Tree | Private 2 | 18 | Width 3ft | 6007555.58457 | 2110185.16197 | 37.7745931492825 | -122.417320912844 | (37.7745931492825, -122.417320912844) | 8 | 2 | 9 | 28853 | 34 | |||
| 1068 | 189619 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1022 Harrison St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 0ft | 6010873.70675 | 2110523.15136 | 37.7757073139658 | -122.405866629254 | (37.7757073139658, -122.405866629254) | 14 | 2 | 9 | 28853 | 34 | |||
| 2900 | 34181 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 111 Gilbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1997 12:00:00 AM | 12 | Permit Number 38007 | 6011922.99653 | 2109561.23009 | 37.7731247245485 | -122.402169209655 | (37.7731247245485, -122.402169209655) | 14 | 2 | 9 | 28853 | 34 | |
| 4189 | 192124 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 807 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 25 | Width 4ft | 6011038.85416 | 2113311.43716 | 37.783372530757 | -122.405491758548 | (37.783372530757, -122.405491758548) | 12 | 2 | 9 | 28853 | 34 | |||
| 5432 | 189807 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 220 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6010828.58743 | 2107359.89419 | 37.7670192127893 | -122.405799840205 | (37.7670192127893, -122.405799840205) | 8 | 4 | 8 | 28853 | 19 | |||
| 5855 | 189614 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1022 Harrison St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 0ft | 6011103.60933 | 2110745.72652 | 37.7763313085817 | -122.405087010566 | (37.7763313085817, -122.405087010566) | 14 | 2 | 9 | 28853 | 34 | |||
| 7059 | 192064 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 400 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011310.89762 | 2107471.79469 | 37.7673534269378 | -122.404139471354 | (37.7673534269378, -122.404139471354) | 8 | 2 | 8 | 28853 | 20 | |||
| 7810 | 192162 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1500 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 29 | Width 5ft | Permit Number 779453 | 6007414.0762 | 2109937.75552 | 37.7739058675964 | -122.417792878858 | (37.7739058675964, -122.417792878858) | 8 | 2 | 9 | 28853 | 19 | ||
| 8181 | 192121 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 807 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 27 | Width 4ft | 6010922.27002 | 2113199.63335 | 37.783059024392 | -122.405887217429 | (37.783059024392, -122.405887217429) | 12 | 2 | 9 | 28853 | 34 | |||
| 8438 | 189632 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 9 | : | Tree | Private 2 | 7 | Width 3ft | 6007298.00895 | 2110457.3775 | 37.7753260931545 | -122.4182312237 | (37.7753260931545, -122.4182312237) | 8 | 2 | 9 | 28853 | 34 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );