trees
52 rows where Zip Codes = 28859 and qSpecies_id = 148 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2658 | 91806 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2945 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009025.873084 | 2101313.36822 | 37.7503158463726 | -122.411607913685 | (37.7503158463726, -122.411607913685) | 2 | 4 | 7 | 28859 | 19 | |||
24063 | 91815 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2601 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008917.295639 | 2103308.711999 | 37.755788521075 | -122.412124384346 | (37.755788521075, -122.412124384346) | 2 | 4 | 7 | 28859 | 19 | ||
26852 | 23014 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 790 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006206.16059 | 2105091.96533 | 37.7605324270074 | -122.421627026238 | (37.7605324270074, -122.421627026238) | 2 | 4 | 5 | 28859 | 19 | |||
43287 | 91814 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2621 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008916 | 2103203 | 37.7554981871043 | -122.412121394411 | (37.7554981871043, -122.412121394411) | 2 | 4 | 7 | 28859 | 19 | ||
57956 | 122512 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 721 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3x6 | 6006289 | 2105371 | 37.7613032617497 | -122.421360338097 | (37.7613032617497, -122.421360338097) | 2 | 4 | 7 | 28859 | 19 | |||
58720 | 109763 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 899 VALENCIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 772584 | 6006382.7 | 2104441.4 | 37.7587560793788 | -122.420970264824 | (37.7587560793788, -122.420970264824) | 2 | 4 | 7 | 28859 | 19 | ||
69655 | 122511 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 715 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x6 | 6006287 | 2105397 | 37.7613745389022 | -122.421369101713 | (37.7613745389022, -122.421369101713) | 2 | 4 | 7 | 28859 | 19 | |||
70694 | 23003 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 740X Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/1994 12:00:00 AM | 8 | 3X3 | 6006197 | 2105252 | 37.7609713282095 | -122.421670075458 | (37.7609713282095, -122.421670075458) | 2 | 4 | 5 | 28859 | 19 | ||
76312 | 91803 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2989 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009039.569733 | 2101067.518808 | 37.7496415669707 | -122.411543181878 | (37.7496415669707, -122.411543181878) | 2 | 4 | 7 | 28859 | 19 | |||
91070 | 91801 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3071 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009060.650721 | 2100687.104692 | 37.7485982168729 | -122.4114434106 | (37.7485982168729, -122.4114434106) | 2 | 4 | 7 | 28859 | 19 | |||
92897 | 121027 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1101X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6007689 | 2103175 | 37.7553523831166 | -122.416362767289 | (37.7553523831166, -122.416362767289) | 2 | 4 | 7 | 28859 | 19 | |||
93430 | 91821 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2395x Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008850.144084 | 2104529.130727 | 37.7591357459563 | -122.412442878611 | (37.7591357459563, -122.412442878611) | 2 | 4 | 7 | 28859 | 19 | ||
97736 | 121026 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1101X South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6007689 | 2103175 | 37.7553523831166 | -122.416362767289 | (37.7553523831166, -122.416362767289) | 2 | 4 | 7 | 28859 | 19 | |||
97984 | 122513 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 721 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3x6 | 6006289 | 2105371 | 37.7613032617497 | -122.421360338097 | (37.7613032617497, -122.421360338097) | 2 | 4 | 7 | 28859 | 19 | |||
105706 | 91813 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2625 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008924.574272 | 2103174.237398 | 37.7554196925843 | -122.412089709208 | (37.7554196925843, -122.412089709208) | 2 | 4 | 7 | 28859 | 19 | ||
107166 | 91802 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2997 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009042.060032 | 2101022.818937 | 37.7495189707644 | -122.411531412589 | (37.7495189707644, -122.411531412589) | 2 | 4 | 7 | 28859 | 19 | |||
114348 | 23005 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 766 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1997 12:00:00 AM | 8 | 3X3 | 6006192.39683 | 2105141.54299 | 37.7606677795421 | -122.421678150262 | (37.7606677795421, -122.421678150262) | 2 | 4 | 5 | 28859 | 19 | ||
124837 | 122515 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 758 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x6 | 6006189 | 2105199 | 37.7608253514989 | -122.421693979475 | (37.7608253514989, -122.421693979475) | 2 | 4 | 5 | 28859 | 19 | |||
126438 | 62108 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 295 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773730 | 6006765.73996863 | 2102077.12480026 | 37.7522859081758 | -122.419477800449 | (37.7522859081758, -122.419477800449) | 2 | 4 | 7 | 28859 | 19 |
128877 | 122821 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 777 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6006304 | 2105101 | 37.7605627505881 | -122.421289285481 | (37.7605627505881, -122.421289285481) | 2 | 4 | 7 | 28859 | 19 | |||
143359 | 91820 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2395x Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008850.144084 | 2104529.130727 | 37.7591357459563 | -122.412442878611 | (37.7591357459563, -122.412442878611) | 2 | 4 | 7 | 28859 | 19 | ||
150496 | 91810 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2701x Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008948.888017 | 2102724.532648 | 37.7541862688692 | -122.411973846441 | (37.7541862688692, -122.411973846441) | 2 | 4 | 7 | 28859 | 19 | ||
152517 | 23013 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 780 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6006206.16059 | 2105091.96533 | 37.7605324270074 | -122.421627026238 | (37.7605324270074, -122.421627026238) | 2 | 4 | 5 | 28859 | 19 | |||
152875 | 109765 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 899 VALENCIA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 772584 | 6006382.7 | 2104441.4 | 37.7587560793788 | -122.420970264824 | (37.7587560793788, -122.420970264824) | 2 | 4 | 7 | 28859 | 19 | ||
152934 | 91825 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2147 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008764.72509 | 2105924.073265 | 37.7629611450186 | -122.412836921531 | (37.7629611450186, -122.412836921531) | 8 | 4 | 7 | 28859 | 19 | ||
153570 | 91807 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2859 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008997.743306 | 2101817.227115 | 37.7516977523567 | -122.411740786814 | (37.7516977523567, -122.411740786814) | 2 | 4 | 7 | 28859 | 19 | |||
159509 | 109761 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 899 VALENCIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 1 | 3x3 | Permit Number 772584 | 6006382.7 | 2104441.4 | 37.7587560793788 | -122.420970264824 | (37.7587560793788, -122.420970264824) | 2 | 4 | 7 | 28859 | 19 | |
164777 | 91822 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2345 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008829.344656 | 2104857.328808 | 37.7600357358129 | -122.412538013148 | (37.7600357358129, -122.412538013148) | 2 | 4 | 7 | 28859 | 19 | ||
171013 | 109764 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 899 VALENCIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 772584 | 6006382.7 | 2104441.4 | 37.7587560793788 | -122.420970264824 | (37.7587560793788, -122.420970264824) | 2 | 4 | 7 | 28859 | 19 | ||
173036 | 121025 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1101X South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6007689 | 2103175 | 37.7553523831166 | -122.416362767289 | (37.7553523831166, -122.416362767289) | 2 | 4 | 7 | 28859 | 19 | |||
179065 | 109766 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 899 VALENCIA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 772584 | 6006382.7 | 2104441.4 | 37.7587560793788 | -122.420970264824 | (37.7587560793788, -122.420970264824) | 2 | 4 | 7 | 28859 | 19 | ||
185602 | 121028 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1101X South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6007689 | 2103175 | 37.7553523831166 | -122.416362767289 | (37.7553523831166, -122.416362767289) | 2 | 4 | 7 | 28859 | 19 | |||
866 | 28332 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3247 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2004 12:00:00 AM | 9 | 3x3 | 6006498.83651 | 2099346.51324 | 37.74477323292 | -122.420207017141 | (37.74477323292, -122.420207017141) | 2 | 7 | 7 | 28859 | 2 | ||
9814 | 28339 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3125 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2004 12:00:00 AM | 3 | 3X3 | 6007038.71469 | 2100348.34949 | 37.7475544551381 | -122.418411239379 | (37.7475544551381, -122.418411239379) | 2 | 7 | 7 | 28859 | 2 | ||
15454 | 28326 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3284 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006311.45985 | 2099177.31377 | 37.7442980895932 | -122.420842920924 | (37.7442980895932, -122.420842920924) | 2 | 7 | 7 | 28859 | 2 | ||
27923 | 28655 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3395 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2004 12:00:00 AM | 3 | 4X4 | 6006036.04282 | 2098446.39955 | 37.7422756364725 | -122.421743350168 | (37.7422756364725, -122.421743350168) | 2 | 7 | 7 | 28859 | 2 | ||
31330 | 28335 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3221 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006572.11195 | 2099482.47917 | 37.7451506932372 | -122.419963290861 | (37.7451506932372, -122.419963290861) | 2 | 7 | 7 | 28859 | 2 | ||
34558 | 28331 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3281 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006413.77303 | 2099188.67497 | 37.7443350512574 | -122.420489949359 | (37.7443350512574, -122.420489949359) | 2 | 7 | 7 | 28859 | 2 | ||
39865 | 26270 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 16 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2015 10:26:00 AM | 3 | 3X3 | 6006157.7043564 | 2098703.0541301 | 37.7429872120583 | -122.42134090318 | (37.7429872120583, -122.42134090318) | 2 | 7 | 7 | 28859 | 2 | ||
42186 | 15613 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3435 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2004 12:00:00 AM | 6 | 3x3 | 6005895.33669 | 2098270.89959 | 37.7417858175205 | -122.422217403662 | (37.7417858175205, -122.422217403662) | 2 | 7 | 7 | 28859 | 2 | ||
43351 | 28363 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3469 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2005 12:00:00 AM | 3 | 3X3 | 6005899.78718 | 2098063.61718 | 37.7412169177624 | -122.422187292293 | (37.7412169177624, -122.422187292293) | 2 | 7 | 7 | 28859 | 2 | ||
44088 | 28340 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3125 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 3 | 3X3 | 6007038.71469 | 2100348.34949 | 37.7475544551381 | -122.418411239379 | (37.7475544551381, -122.418411239379) | 2 | 7 | 7 | 28859 | 2 | ||
44529 | 97900 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 375X Precita Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 3x4 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | 2 | 7 | 7 | 28859 | 2 | ||
61354 | 24389 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3641 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2004 12:00:00 AM | 3 | 4X4 | 6005406.19827 | 2096949.60563 | 37.7381302401684 | -122.423814755555 | (37.7381302401684, -122.423814755555) | 2 | 7 | 7 | 28859 | 2 | ||
62166 | 28334 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3241 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2005 12:00:00 AM | 9 | 3X3 | 6006567.49057 | 2099355.80784 | 37.7448026219753 | -122.419970283481 | (37.7448026219753, -122.419970283481) | 2 | 7 | 7 | 28859 | 2 | ||
74959 | 15604 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3333 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2004 12:00:00 AM | 3 | 4X4 | 6006368.01098 | 2098829.09498 | 37.7433451466609 | -122.420622664534 | (37.7433451466609, -122.420622664534) | 2 | 7 | 7 | 28859 | 2 | ||
75312 | 28323 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3100 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 11 | 4x4 | 6007076.90394 | 2100561.83623 | 37.7481427912413 | -122.418294317161 | (37.7481427912413, -122.418294317161) | 2 | 4 | 7 | 28859 | 2 | ||
81977 | 15597 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3281 MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/03/2013 12:00:00 AM | 9 | 3X3 | 6006413.8 | 2099188.7 | 37.7443351215041 | -122.420489857879 | (37.7443351215041, -122.420489857879) | 2 | 7 | 7 | 28859 | 2 | ||
139774 | 28337 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3209 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006571.86084 | 2099543.08303 | 37.7453170836103 | -122.419968459003 | (37.7453170836103, -122.419968459003) | 2 | 7 | 7 | 28859 | 2 | ||
167663 | 28324 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3120 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2004 12:00:00 AM | 3 | 4X4 | 6006915.49742 | 2100327.36397 | 37.7474898965029 | -122.41883582999 | (37.7474898965029, -122.41883582999) | 2 | 7 | 7 | 28859 | 2 | ||
173038 | 26271 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 16 Virginia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2004 12:00:00 AM | 3 | 3X3 | 6006157.7043564 | 2098703.0541301 | 37.7429872120583 | -122.42134090318 | (37.7429872120583, -122.42134090318) | 2 | 7 | 7 | 28859 | 2 | ||
193203 | 28327 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3435 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2004 12:00:00 AM | 3 | 3x3 | 6005943.50429 | 2098256.08104 | 37.7417478459244 | -122.422049803265 | (37.7417478459244, -122.422049803265) | 2 | 7 | 7 | 28859 | 2 |
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) );