trees
137 rows where Fire Prevention Districts = 2 and qSpecies_id = 123 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4885 | 71351 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 118 Danvers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2008 12:00:00 AM | 3x3 | Permit Number 50915 | 5999898.11886666 | 2105092.21291824 | 37.7601753897516 | -122.44344360556 | (37.7601753897516, -122.44344360556) | 2 | 4 | 5 | 28862 | 3 | ||
75224 | 52663 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 772 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50440 | 6001423.61779826 | 2102059.9147838 | 37.7519363103852 | -122.437950438082 | (37.7519363103852, -122.437950438082) | 2 | 4 | 5 | 28862 | 22 | |
105739 | 43561 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 598 28th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50500 | 6002046.37252319 | 2099459.05244765 | 37.7448303525831 | -122.435610815213 | (37.7448303525831, -122.435610815213) | 2 | 7 | 5 | 63 | 22 | ||
98123 | 241389 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 47 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002625.89983 | 2096003.53123 | 37.7353751906151 | -122.43336004273 | (37.7353751906151, -122.43336004273) | 2 | 7 | 5 | 63 | 7 | |||
109816 | 241388 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1769 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6003420.97531 | 2097978.60034 | 37.7408433528415 | -122.430752071748 | (37.7408433528415, -122.430752071748) | 2 | 7 | 5 | 63 | 7 | |||
115294 | 246445 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 457 Duncan St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6003558.45361 | 2099788.20108 | 37.7458198862793 | -122.430405804901 | (37.7458198862793, -122.430405804901) | 2 | 7 | 5 | 63 | 22 | |||
47749 | 84105 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3909 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50417 | 6003719.39167552 | 2102426.4465388 | 37.7530730069117 | -122.430037470862 | (37.7530730069117, -122.430037470862) | 2 | 4 | 5 | 28862 | 22 | ||
116693 | 84100 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3909 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50417 | 6003719.39167552 | 2102426.4465388 | 37.7530730069117 | -122.430037470862 | (37.7530730069117, -122.430037470862) | 2 | 4 | 5 | 28862 | 22 | ||
93244 | 86800 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 71 Miguel St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2007 12:00:00 AM | 3x3 | Permit Number 49752 | 6003860 | 2097292 | 37.7389829690297 | -122.429185143196 | (37.7389829690297, -122.429185143196) | 2 | 7 | 5 | 63 | 7 | |||
57267 | 241390 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 381 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004068.12547 | 2098354.29911 | 37.7419115792635 | -122.428541241382 | (37.7419115792635, -122.428541241382) | 2 | 7 | 5 | 63 | 7 | |||
2223 | 241387 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 43 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 3ft | 6004298.90777 | 2098020.68858 | 37.7410086185538 | -122.42771950655 | (37.7410086185538, -122.42771950655) | 2 | 7 | 5 | 63 | 7 | |||
109877 | 241372 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3783 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004512.71197 | 2101888.89737 | 37.7516419200596 | -122.427255725271 | (37.7516419200596, -122.427255725271) | 2 | 4 | 5 | 28862 | 22 | |||
104883 | 241373 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3783 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004532.87463 | 2101890.40961 | 37.7516472125622 | -122.427186107874 | (37.7516472125622, -122.427186107874) | 2 | 4 | 5 | 28862 | 22 | |||
123335 | 241374 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3783 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004551.11836 | 2101892.73239 | 37.7516546220636 | -122.427123184105 | (37.7516546220636, -122.427123184105) | 2 | 4 | 5 | 28862 | 22 | |||
141067 | 241375 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3783 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004575.52977 | 2101893.77166 | 37.7516588560771 | -122.427038840268 | (37.7516588560771, -122.427038840268) | 2 | 4 | 5 | 28862 | 22 | |||
84968 | 241376 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3777 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004606.4364 | 2101890.62925 | 37.7516519753774 | -122.426931737306 | (37.7516519753774, -122.426931737306) | 2 | 4 | 5 | 28862 | 22 | |||
104248 | 241377 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 281 27th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004660.79755 | 2100144.09881 | 37.7468594809746 | -122.426619392873 | (37.7468594809746, -122.426619392873) | 2 | 7 | 5 | 63 | 22 | |||
92135 | 241378 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 273 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004715.15963 | 2100148.28162 | 37.746874039199 | -122.426431711567 | (37.746874039199, -122.426431711567) | 2 | 7 | 5 | 63 | 22 | |||
144328 | 88018 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3926 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51046 | 6004957.7 | 2095821.3 | 37.7350068377073 | -122.425285172259 | (37.7350068377073, -122.425285172259) | 2 | 7 | 5 | 28861 | 2 | |||
67982 | 241367 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3747 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005339.63853 | 2104274.22686 | 37.7582382098444 | -122.424565763112 | (37.7582382098444, -122.424565763112) | 2 | 4 | 5 | 28859 | 19 | |||
20731 | 63489 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 319 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50934 | 6006645.5795298 | 2096080.30995427 | 37.7358132351331 | -122.419467931102 | (37.7358132351331, -122.419467931102) | 2 | 7 | 7 | 28859 | 2 | ||
17020 | 82125 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 317 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50070 | 6006739.55759841 | 2104266.9934198 | 37.75829730851 | -122.41972370977 | (37.75829730851, -122.41972370977) | 2 | 4 | 7 | 28859 | 19 |
67177 | 241335 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Coso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007049.61155 | 2099992.5386 | 37.7465780921238 | -122.418348334311 | (37.7465780921238, -122.418348334311) | 2 | 7 | 7 | 28859 | 2 | |||
134611 | 241336 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 11 Lundys Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007215.53058 | 2099620.48751 | 37.7455658619754 | -122.417748235597 | (37.7455658619754, -122.417748235597) | 2 | 7 | 7 | 28859 | 2 | |||
135948 | 84422 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3324-3330 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50579 | 6007386.65215888 | 2105022.29149516 | 37.7604076136969 | -122.417539297454 | (37.7604076136969, -122.417539297454) | 2 | 4 | 7 | 28859 | 19 | ||
175176 | 84150 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3324-3330 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50579 | 6007386.65215888 | 2105022.29149516 | 37.7604076136969 | -122.417539297454 | (37.7604076136969, -122.417539297454) | 2 | 4 | 7 | 28859 | 19 | ||
53750 | 91599 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 700 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007449 | 2105508 | 37.7617447647779 | -122.41735808585 | (37.7617447647779, -122.41735808585) | 2 | 4 | 7 | 28859 | 19 | ||
92157 | 121263 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 700 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6007449 | 2105508 | 37.7617447647779 | -122.41735808585 | (37.7617447647779, -122.41735808585) | 2 | 4 | 7 | 28859 | 19 | |||
95212 | 91600 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 722 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007467 | 2105381 | 37.7613970649262 | -122.417286830828 | (37.7613970649262, -122.417286830828) | 2 | 4 | 7 | 28859 | 19 | ||
105407 | 241312 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 700 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007473.64747 | 2105479.75896 | 37.7616686081336 | -122.41727083858 | (37.7616686081336, -122.41727083858) | 2 | 4 | 7 | 28859 | 19 | |||
152443 | 91602 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 754 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007474 | 2105260 | 37.7610652207705 | -122.417254045994 | (37.7610652207705, -122.417254045994) | 2 | 4 | 7 | 28859 | 19 | ||
123745 | 241313 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 720 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007476.61227 | 2105442.18225 | 37.7615655979969 | -122.417257921613 | (37.7615655979969, -122.417257921613) | 2 | 4 | 7 | 28859 | 19 | |||
177426 | 241314 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 722 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007476.75646 | 2105385.74126 | 37.7614106322283 | -122.417253423206 | (37.7614106322283, -122.417253423206) | 2 | 4 | 7 | 28859 | 19 | |||
47891 | 37711 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 720 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 6 | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.7616070561613 | -122.417234652367 | (37.7616070561613, -122.417234652367) | 2 | 4 | 7 | 28859 | 19 | |
136903 | 37712 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 720 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 4 | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.7616070561613 | -122.417234652367 | (37.7616070561613, -122.417234652367) | 2 | 4 | 7 | 28859 | 19 | |
25956 | 241315 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 754 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007487.69135 | 2105254.04954 | 37.7610496524471 | -122.417206271746 | (37.7610496524471, -122.417206271746) | 2 | 4 | 7 | 28859 | 19 | |||
57032 | 91601 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 746 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007497.69689 | 2105311.935767 | 37.7612091575166 | -122.417175768763 | (37.7612091575166, -122.417175768763) | 2 | 4 | 7 | 28859 | 19 | |||
87512 | 91604 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 802 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007516.377022 | 2104974.620116 | 37.7602840176254 | -122.417087260164 | (37.7602840176254, -122.417087260164) | 2 | 4 | 7 | 28859 | 19 | ||
148664 | 91605 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 814 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007520.10207 | 2104907.355044 | 37.7600995328259 | -122.417069610712 | (37.7600995328259, -122.417069610712) | 2 | 4 | 7 | 28859 | 19 | ||
41188 | 91672 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 731 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007532.676036 | 2105403.706321 | 37.7614631059869 | -122.417061293148 | (37.7614631059869, -122.417061293148) | 2 | 4 | 7 | 28859 | 19 | ||
161394 | 91673 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 731 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007532.676036 | 2105403.706321 | 37.7614631059869 | -122.417061293148 | (37.7614631059869, -122.417061293148) | 2 | 4 | 7 | 28859 | 19 | ||
35434 | 91607 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 882 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007541.210677 | 2104526.186296 | 37.759054118783 | -122.416969598799 | (37.759054118783, -122.416969598799) | 2 | 4 | 7 | 28859 | 19 | ||
160938 | 241304 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 731 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007541.98711 | 2105410.71397 | 37.7614828711499 | -122.417029586455 | (37.7614828711499, -122.417029586455) | 2 | 4 | 7 | 28859 | 19 | |||
145660 | 91669 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 765 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007543.215311 | 2105213.393874 | 37.7609411449227 | -122.417011357225 | (37.7609411449227, -122.417011357225) | 2 | 4 | 7 | 28859 | 19 | |||
79863 | 241303 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 731 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007544.46079 | 2105381.89304 | 37.7614038747014 | -122.417018988842 | (37.7614038747014, -122.417018988842) | 2 | 4 | 7 | 28859 | 19 | |||
168558 | 241302 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 741 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007545.5728 | 2105350.70249 | 37.7613182952255 | -122.417012932805 | (37.7613182952255, -122.417012932805) | 2 | 4 | 7 | 28859 | 19 | |||
69848 | 91667 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 793 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007551.894714 | 2105056.665982 | 37.7605112945984 | -122.416970234051 | (37.7605112945984, -122.416970234051) | 2 | 4 | 7 | 28859 | 19 | ||
136593 | 91668 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 793 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007551.894714 | 2105056.665982 | 37.7605112945984 | -122.416970234051 | (37.7605112945984, -122.416970234051) | 2 | 4 | 7 | 28859 | 19 | ||
193505 | 91666 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 793 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007551.894714 | 2105056.665982 | 37.7605112945984 | -122.416970234051 | (37.7605112945984, -122.416970234051) | 2 | 4 | 7 | 28859 | 19 | ||
103723 | 241301 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 765 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007553.45453 | 2105201.24032 | 37.7609083500518 | -122.416975083028 | (37.7609083500518, -122.416975083028) | 2 | 4 | 7 | 28859 | 19 | |||
139882 | 91608 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 918 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007553.688973 | 2104300.922411 | 37.758436297925 | -122.416910482813 | (37.758436297925, -122.416910482813) | 2 | 4 | 7 | 28859 | 19 | |||
95383 | 241300 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 793 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007560.00542 | 2105104.33275 | 37.7606426327636 | -122.416945560095 | (37.7606426327636, -122.416945560095) | 2 | 4 | 7 | 28859 | 19 | |||
170208 | 91664 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 815 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007560.040875 | 2104909.5668 | 37.7601078524477 | -122.4169316378 | (37.7601078524477, -122.4169316378) | 2 | 4 | 7 | 28859 | 19 | ||
193578 | 241299 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 793 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007561.10393 | 2105083.16851 | 37.7605845824436 | -122.416940261287 | (37.7605845824436, -122.416940261287) | 2 | 4 | 7 | 28859 | 19 | |||
108520 | 241298 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 793 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007561.5863 | 2105063.97813 | 37.760531917228 | -122.416937233294 | (37.760531917228, -122.416937233294) | 2 | 4 | 7 | 28859 | 19 | |||
129554 | 120951 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 741 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6007568 | 2105341 | 37.7612929159977 | -122.416934678899 | (37.7612929159977, -122.416934678899) | 2 | 4 | 7 | 28859 | 19 | |||
146984 | 91609 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 976 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007571.644451 | 2103976.864237 | 37.7575475186204 | -122.416825426207 | (37.7575475186204, -122.416825426207) | 2 | 4 | 7 | 28859 | 19 | ||
89482 | 91663 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 859 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007573.699386 | 2104662.928197 | 37.7594314080197 | -122.416866925134 | (37.7594314080197, -122.416866925134) | 2 | 4 | 7 | 28859 | 19 | ||
142131 | 91614 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1140 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007588 | 2102997 | 37.7548579556474 | -122.416699447347 | (37.7548579556474, -122.416699447347) | 2 | 4 | 7 | 28859 | 19 | |||
163045 | 91611 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1086 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007607.027989 | 2103338.253155 | 37.7557960290434 | -122.416657816418 | (37.7557960290434, -122.416657816418) | 2 | 4 | 7 | 28859 | 19 | |||
35939 | 91612 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1108 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007615.164408 | 2103191.40433 | 37.755393273338 | -122.416619275738 | (37.755393273338, -122.416619275738) | 2 | 4 | 7 | 28859 | 19 | |||
111765 | 91613 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1116 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 10 | 3x3 | 6007617.645495 | 2103146.62493 | 37.7552704588724 | -122.416607523387 | (37.7552704588724, -122.416607523387) | 2 | 4 | 7 | 28859 | 19 | |||
50197 | 91660 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 999 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007618.393891 | 2103856.158531 | 37.7572187178563 | -122.416655196612 | (37.7572187178563, -122.416655196612) | 2 | 4 | 7 | 28859 | 19 | ||
1298 | 91659 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1015 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007624.666917 | 2103742.941155 | 37.7569082017019 | -122.4166254819 | (37.7569082017019, -122.4166254819) | 2 | 4 | 7 | 28859 | 19 | |||
84687 | 91615 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1176 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007636.253645 | 2102810.779435 | 37.754349350274 | -122.416519382003 | (37.754349350274, -122.416519382003) | 2 | 4 | 7 | 28859 | 19 | |||
132267 | 91658 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1073 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007642.630657 | 2103418.725072 | 37.7560189888407 | -122.416540390694 | (37.7560189888407, -122.416540390694) | 2 | 4 | 7 | 28859 | 19 | |||
41845 | 91616 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1200X South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007645 | 2102652 | 37.7539138699857 | -122.416477888477 | (37.7539138699857, -122.416477888477) | 2 | 4 | 7 | 28859 | 19 | ||
43855 | 91617 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1200X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007645 | 2102652 | 37.7539138699857 | -122.416477888477 | (37.7539138699857, -122.416477888477) | 2 | 4 | 7 | 28859 | 19 | ||
60767 | 91618 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1240 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007656.818859 | 2102429.616316 | 37.7533039196294 | -122.41642126514 | (37.7533039196294, -122.41642126514) | 2 | 4 | 7 | 28859 | 19 | |||
77309 | 91657 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1133 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007662.546411 | 2103059.279009 | 37.7550331520704 | -122.416446055556 | (37.7550331520704, -122.416446055556) | 2 | 4 | 7 | 28859 | 19 | |||
67599 | 91656 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1141 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007665.027497 | 2103014.499609 | 37.7549103375799 | -122.416434303552 | (37.7549103375799, -122.416434303552) | 2 | 4 | 7 | 28859 | 19 | |||
108205 | 91655 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1155 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007669.369399 | 2102936.135663 | 37.7546954122234 | -122.416413737633 | (37.7546954122234, -122.416413737633) | 2 | 4 | 7 | 28859 | 19 | |||
56651 | 91619 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1286 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 10 | 3x3 | 6007670.444381 | 2102173.036115 | 37.7526001749043 | -122.416355973027 | (37.7526001749043, -122.416355973027) | 2 | 4 | 7 | 28859 | 19 | |||
158272 | 91620 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1290 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007671.629207 | 2102150.724826 | 37.7525389797951 | -122.41635029552 | (37.7525389797951, -122.41635029552) | 2 | 4 | 7 | 28859 | 19 | |||
81154 | 91654 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1169 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007673.711302 | 2102857.771696 | 37.7544804867979 | -122.416393171829 | (37.7544804867979, -122.416393171829) | 2 | 4 | 7 | 28859 | 19 | |||
53423 | 91645 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1300X South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007675.941296 | 2102071.044433 | 37.7523204379956 | -122.416329740365 | (37.7523204379956, -122.416329740365) | 2 | 4 | 7 | 28859 | 19 | |||
157671 | 91653 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1199 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007683.015377 | 2102689.848948 | 37.7540199323813 | -122.416349102661 | (37.7540199323813, -122.416349102661) | 2 | 4 | 7 | 28859 | 19 | ||
188771 | 91621 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1358 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007694.688201 | 2101746.136705 | 37.7514293691601 | -122.416241900686 | (37.7514293691601, -122.416241900686) | 2 | 4 | 7 | 28859 | 19 | |||
87982 | 91650 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1245 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007697.947405 | 2102409.42617 | 37.7532507948704 | -122.416277603857 | (37.7532507948704, -122.416277603857) | 2 | 4 | 7 | 28859 | 19 | ||
105398 | 91651 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1245 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007697.947405 | 2102409.42617 | 37.7532507948704 | -122.416277603857 | (37.7532507948704, -122.416277603857) | 2 | 4 | 7 | 28859 | 19 | ||
164866 | 91649 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1245 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007697.947405 | 2102409.42617 | 37.7532507948704 | -122.416277603857 | (37.7532507948704, -122.416277603857) | 2 | 4 | 7 | 28859 | 19 | ||
171522 | 91648 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1245 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007697.947405 | 2102409.42617 | 37.7532507948704 | -122.416277603857 | (37.7532507948704, -122.416277603857) | 2 | 4 | 7 | 28859 | 19 | ||
29262 | 91646 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1271 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007705.648787 | 2102264.402582 | 37.7528530260896 | -122.416240700263 | (37.7528530260896, -122.416240700263) | 2 | 4 | 7 | 28859 | 19 | ||
177703 | 91647 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1271 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007705.648787 | 2102264.402582 | 37.7528530260896 | -122.416240700263 | (37.7528530260896, -122.416240700263) | 2 | 4 | 7 | 28859 | 19 | ||
39867 | 91624 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1424 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007717.03025 | 2101352.89464 | 37.7503508716121 | -122.416136791792 | (37.7503508716121, -122.416136791792) | 2 | 4 | 7 | 28859 | 19 | |||
38921 | 91625 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1434 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 10 | 3x3 | 6007720.12849 | 2101296.976541 | 37.7501975073399 | -122.416122118115 | (37.7501975073399, -122.416122118115) | 2 | 4 | 7 | 28859 | 19 | |||
135561 | 91626 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1450 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007725.085674 | 2101207.507592 | 37.749952124518 | -122.416098640357 | (37.749952124518, -122.416098640357) | 2 | 4 | 7 | 28859 | 19 | |||
176270 | 91644 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1343 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007729.450223 | 2101838.070556 | 37.7516837533185 | -122.416128199355 | (37.7516837533185, -122.416128199355) | 2 | 4 | 7 | 28859 | 19 | |||
94776 | 91627 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1468 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007730.662506 | 2101106.855019 | 37.7496760688109 | -122.416072228065 | (37.7496760688109, -122.416072228065) | 2 | 4 | 7 | 28859 | 19 | |||
68475 | 91629 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1474 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007732.521449 | 2101073.304189 | 37.7495840503135 | -122.416063424016 | (37.7495840503135, -122.416063424016) | 2 | 4 | 7 | 28859 | 19 | ||
111472 | 91628 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1474 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007732.521449 | 2101073.304189 | 37.7495840503135 | -122.416063424016 | (37.7495840503135, -122.416063424016) | 2 | 4 | 7 | 28859 | 19 | ||
177434 | 91643 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1367 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007737.207562 | 2101703.625981 | 37.7513150351075 | -122.416091852961 | (37.7513150351075, -122.416091852961) | 2 | 4 | 7 | 28859 | 19 | |||
59988 | 91630 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1490x South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007737.478632 | 2100983.83524 | 37.7493386674544 | -122.41603994665 | (37.7493386674544, -122.41603994665) | 2 | 4 | 7 | 28859 | 19 | |||
60318 | 91631 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1500 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007741.508083 | 2100911.11035 | 37.7491392078361 | -122.416020863166 | (37.7491392078361, -122.416020863166) | 2 | 4 | 7 | 28859 | 19 | |||
149994 | 91642 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007742.379122 | 2101613.996265 | 37.7510692229497 | -122.41606762223 | (37.7510692229497, -122.41606762223) | 2 | 4 | 7 | 28859 | 19 | |||
100115 | 91632 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1540 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007748.949212 | 2100776.810346 | 37.748770868614 | -122.415985622241 | (37.748770868614, -122.415985622241) | 2 | 4 | 7 | 28859 | 19 | |||
15680 | 91641 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1401X South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007749.533216 | 2101489.31094 | 37.7507272674606 | -122.416034053567 | (37.7507272674606, -122.416034053567) | 2 | 4 | 7 | 28859 | 19 | |||
6410 | 91640 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1427 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007757.588641 | 2101343.923892 | 37.7503285203588 | -122.415995902486 | (37.7503285203588, -122.415995902486) | 2 | 4 | 7 | 28859 | 19 | |||
96199 | 91639 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1435 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007760.067233 | 2101299.189418 | 37.7502058289413 | -122.415984163776 | (37.7502058289413, -122.415984163776) | 2 | 4 | 7 | 28859 | 19 | |||
42600 | 91638 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1453 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007765.644065 | 2101198.536844 | 37.7499297732176 | -122.415957751819 | (37.7499297732176, -122.415957751819) | 2 | 4 | 7 | 28859 | 19 |
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) );