trees
62 rows where Fire Prevention Districts = 9 and qSpecies_id = 151
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1406 | 75132 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 148X Paris St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002992.10347 | 2092540.72564 | 37.7258878789975 | -122.431846767938 | (37.7258878789975, -122.431846767938) | 9 | 7 | 6 | 28861 | 5 | ||
| 1945 | 44489 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 16 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 8 | Permit Number 43794 | 6005364.27294 | 2093438.07689 | 37.7284859970226 | -122.423710107629 | (37.7284859970226, -122.423710107629) | 9 | 7 | 6 | 28861 | 5 | |
| 9740 | 75309 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 125 Excelsior Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6002784.56496 | 2092514.51527 | 37.7258041440316 | -122.432562342276 | (37.7258041440316, -122.432562342276) | 9 | 7 | 6 | 28861 | 5 | ||
| 16040 | 78382 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 606 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6001696.66297 | 2089972.42102 | 37.7187623714737 | -122.436141300492 | (37.7187623714737, -122.436141300492) | 9 | 7 | 6 | 28861 | 5 | ||||
| 16439 | 67516 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 327 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31052 | 5997915.17390153 | 2093778.82856929 | 37.7289983088646 | -122.449486452558 | (37.7289983088646, -122.449486452558) | 9 | 7 | 4 | 28861 | 40 | ||
| 18805 | 78255 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 512 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001977.46264 | 2090420.81734 | 37.7200095171006 | -122.435202744616 | (37.7200095171006, -122.435202744616) | 9 | 7 | 6 | 28861 | 5 | |||
| 21835 | 65598 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 966 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/1990 12:00:00 AM | Permit Number 28500 | 6001950.73496364 | 2088338.48153862 | 37.7142903680478 | -122.435146273727 | (37.7142903680478, -122.435146273727) | 9 | 7 | 6 | 28861 | 5 | ||
| 25626 | 68823 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 306 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32772 | 5999450.43970514 | 2094100.18276953 | 37.729968379033 | -122.444202023687 | (37.729968379033, -122.444202023687) | 9 | 7 | 4 | 63 | 40 | ||
| 34670 | 66326 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 135 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29445 | 6000528.81306712 | 2095194.53475792 | 37.7330346787859 | -122.440552427184 | (37.7330346787859, -122.440552427184) | 9 | 7 | 5 | 63 | 40 | ||
| 43235 | 57575 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 30 Beverly St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1994 12:00:00 AM | Permit Number 16442 | 5991446.93129096 | 2089419.02625002 | 37.7166552263353 | -122.471529877911 | (37.7166552263353, -122.471529877911) | 9 | 8 | 6 | 64 | 24 | ||
| 43590 | 66306 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 311 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29421 | 6000730.96676364 | 2094981.50970271 | 37.7324612706981 | -122.439838262312 | (37.7324612706981, -122.439838262312) | 9 | 7 | 5 | 63 | 40 | ||
| 44026 | 45318 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 651 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44155 | 5993484.7456852 | 2090166.18126819 | 37.718824416648 | -122.464540445707 | (37.718824416648, -122.464540445707) | 9 | 8 | 6 | 64 | 24 | ||
| 49524 | 209294 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 246 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994759.39259 | 2090227.21808 | 37.7190654070329 | -122.460138948468 | (37.7190654070329, -122.460138948468) | 9 | 8 | 6 | 28861 | 24 | |||
| 51461 | 83403 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 24 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50775 | 6000910.29193694 | 2092966.50207531 | 37.7269387297254 | -122.439073931559 | (37.7269387297254, -122.439073931559) | 9 | 7 | 6 | 28861 | 25 | ||
| 51718 | 43139 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1 Gambier St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2000 12:00:00 AM | 4 | Permit Number 42953 | 6005713.11166 | 2093478.24293 | 37.7286159697368 | -122.422507005398 | (37.7286159697368, -122.422507005398) | 9 | 7 | 7 | 309 | 5 | ||
| 55302 | 42355 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 380X Flood Ave | 14 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 9 | 8x90 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
| 60513 | 66307 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 312 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29422 | 6000783.0417172 | 2094985.88569991 | 37.7324762502781 | -122.439658540918 | (37.7324762502781, -122.439658540918) | 9 | 7 | 5 | 63 | 40 | ||
| 70737 | 42344 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 380X Flood Ave | 3 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 8 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
| 76546 | 177523 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 321 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5998908.35184 | 2087935.66658 | 37.7130110981499 | -122.44563295221 | (37.7130110981499, -122.44563295221) | 9 | 7 | 6 | 28861 | 25 | |||
| 78371 | 33939 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 378 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 37898 | 6003089.72357803 | 2091687.1316724 | 37.72354963405 | -122.431448393386 | (37.72354963405, -122.431448393386) | 9 | 7 | 6 | 28861 | 5 | ||
| 82559 | 45319 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 671 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44156 | 5993486.1732944 | 2090289.68128716 | 37.7191636002321 | -122.464544473629 | (37.7191636002321, -122.464544473629) | 9 | 8 | 6 | 64 | 24 | ||
| 83465 | 68848 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 227 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32811 | 5999239.62014085 | 2094052.0632873 | 37.7298242245316 | -122.444927391996 | (37.7298242245316, -122.444927391996) | 9 | 7 | 4 | 28861 | 40 | ||
| 84565 | 177524 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 151 London St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002754.06698 | 2092583.57784 | 37.725992044773 | -122.432672702599 | (37.725992044773, -122.432672702599) | 9 | 7 | 6 | 28861 | 5 | |||
| 87351 | 67921 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 136 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31632 | 6004231.25027354 | 2095231.88967626 | 37.7333473817874 | -122.427754784883 | (37.7333473817874, -122.427754784883) | 9 | 7 | 5 | 28861 | 25 | ||
| 89977 | 56611 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 131 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/01/1992 12:00:00 AM | Permit Number 30977 | 5996730.28293802 | 2098448.69823617 | 37.7417527884603 | -122.453919799435 | (37.7417527884603, -122.453919799435) | 9 | 7 | 4 | 59 | 40 | ||
| 91979 | 66308 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 324 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29423 | 6000783.52973512 | 2095017.02999143 | 37.7325617930594 | -122.439659085695 | (37.7325617930594, -122.439659085695) | 9 | 7 | 5 | 63 | 40 | ||
| 96848 | 43137 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 7 | Permit Number 42953 | 6005718.46144 | 2093462.75751 | 37.728573751977 | -122.422487410986 | (37.728573751977, -122.422487410986) | 9 | 7 | 7 | 309 | 5 | |
| 97377 | 77990 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/01/2000 12:00:00 AM | 8 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
| 97669 | 46851 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 440 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 8 | Permit Number 44919 | 6003321.97716 | 2091035.01696 | 37.7217722323726 | -122.430599024221 | (37.7217722323726, -122.430599024221) | 9 | 7 | 6 | 28861 | 5 | |
| 103700 | 66325 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 131 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29444 | 6000554.87735499 | 2095194.20587313 | 37.7330352599042 | -122.440462292733 | (37.7330352599042, -122.440462292733) | 9 | 7 | 5 | 63 | 40 | ||
| 106884 | 177525 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 100 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006897.82744 | 2093555.37403 | 37.7288945185586 | -122.418416832071 | (37.7288945185586, -122.418416832071) | 9 | 3 | 7 | 309 | 5 | |||
| 111329 | 67925 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 118 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31638 | 6003735.12063535 | 2095135.9515003 | 37.7330558796375 | -122.42946320321 | (37.7330558796375, -122.42946320321) | 9 | 7 | 5 | 28861 | 25 | ||
| 114407 | 68863 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 152 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32826 | 5999067.96340072 | 2093519.65088656 | 37.7283525462917 | -122.445482558018 | (37.7283525462917, -122.445482558018) | 9 | 7 | 4 | 28861 | 40 | ||
| 115628 | 66305 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 309 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29420 | 6000730.88542732 | 2094976.31898746 | 37.7324470135678 | -122.439838171481 | (37.7324470135678, -122.439838171481) | 9 | 7 | 5 | 63 | 40 | ||
| 116585 | 35845 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 478 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 14 | Permit Number 39072 | 6001935.45212 | 2090855.28224 | 37.7212000747131 | -122.435379022551 | (37.7212000747131, -122.435379022551) | 9 | 7 | 6 | 28861 | 5 | |
| 120920 | 46820 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 470 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 10 | Permit Number 44898 | 6003678.47918 | 2090585.52708 | 37.7205582222597 | -122.429334652987 | (37.7205582222597, -122.429334652987) | 9 | 7 | 6 | 28861 | 5 | |
| 121517 | 254611 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 49 Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2018 02:11:00 PM | 3 | 3X3 | 6001570.75814 | 2091771.51604 | 37.7236951277094 | -122.436705214986 | (37.7236951277094, -122.436705214986) | 9 | 7 | 6 | 28861 | 25 | ||
| 122547 | 67014 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 26 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30369 | 5996236.04729315 | 2090068.29308484 | 37.7187138605807 | -122.455023275935 | (37.7187138605807, -122.455023275935) | 9 | 8 | 6 | 28861 | 24 | ||
| 127221 | 53339 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 701 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1994 12:00:00 AM | Permit Number 6231 | 5992196.93740977 | 2089828.37078741 | 37.7178225482589 | -122.468967276491 | (37.7178225482589, -122.468967276491) | 9 | 8 | 6 | 64 | 24 | ||
| 132348 | 66258 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 30 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29361 | 5996943.80390812 | 2098830.64453292 | 37.7428137596531 | -122.453209085576 | (37.7428137596531, -122.453209085576) | 9 | 7 | 4 | 59 | 40 | ||
| 136652 | 65652 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 36 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1990 12:00:00 AM | Permit Number 28571 | 5997207.51801243 | 2099318.0814338 | 37.7441672533821 | -122.452332406716 | (37.7441672533821, -122.452332406716) | 9 | 7 | 4 | 59 | 40 | ||
| 140306 | 57830 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 307 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29419 | 6000730.804091 | 2094971.1282722 | 37.7324327564376 | -122.439838080651 | (37.7324327564376, -122.439838080651) | 9 | 7 | 5 | 63 | 40 | ||
| 144783 | 47523 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 253 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 10 | Permit Number 45394 | 6001752.07719 | 2094109.13644 | 37.7301240051048 | -122.436245638924 | (37.7301240051048, -122.436245638924) | 9 | 7 | 6 | 28861 | 25 | |
| 146059 | 67909 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 124 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32837 | 5999245.55939042 | 2093517.24429142 | 37.7283560753919 | -122.444868429871 | (37.7283560753919, -122.444868429871) | 9 | 7 | 4 | 28861 | 40 | ||
| 152379 | 43141 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 45 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 10 | Permit Number 42954 | 6005755.19133 | 2093338.41647 | 37.7282344107702 | -122.422351602551 | (37.7282344107702, -122.422351602551) | 9 | 7 | 7 | 309 | 5 | |
| 153381 | 45327 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1385 Holloway Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2001 12:00:00 AM | Permit Number 44161 | 5991450.97971793 | 2091205.24216012 | 37.7215599710698 | -122.471645977425 | (37.7215599710698, -122.471645977425) | 9 | 8 | 6 | 64 | 24 | |||
| 154668 | 66320 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 221 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29437 | 6000609.84219196 | 2094923.1600046 | 37.7322941604972 | -122.440252834618 | (37.7322941604972, -122.440252834618) | 9 | 7 | 4 | 63 | 40 | ||
| 161958 | 43169 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 351 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 6 | Permit Number 42978 | 6005826.41516 | 2092089.07714 | 37.7248080153712 | -122.422016663551 | (37.7248080153712, -122.422016663551) | 9 | 7 | 7 | 309 | 5 | |
| 163496 | 77992 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/01/2000 12:00:00 AM | 16 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
| 165181 | 43138 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1 Gambier St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2000 12:00:00 AM | 4 | Permit Number 42953 | 6005709.81909 | 2093489.20943 | 37.7286458955884 | -122.422519166951 | (37.7286458955884, -122.422519166951) | 9 | 7 | 7 | 309 | 5 | ||
| 167774 | 42973 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 538 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | 8 | Permit Number 42858 | 6007050.21421 | 2092033.4761 | 37.7247242929748 | -122.4177821868 | (37.7247242929748, -122.4177821868) | 9 | 7 | 7 | 309 | 28 | |
| 168262 | 45325 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1385 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2001 12:00:00 AM | Permit Number 44161 | 5991450.97971793 | 2091205.24216012 | 37.7215599710698 | -122.471645977425 | (37.7215599710698, -122.471645977425) | 9 | 8 | 6 | 64 | 24 | |||
| 170005 | 67470 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 28 Agua Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | Permit Number 30992 | 5997437.11856426 | 2098613.47951491 | 37.7422457393208 | -122.451487690832 | (37.7422457393208, -122.451487690832) | 9 | 7 | 4 | 59 | 40 | ||
| 170769 | 53492 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 255 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1994 12:00:00 AM | Permit Number 6402 | 5992175.72287884 | 2089558.97106605 | 37.7170816163747 | -122.469021010071 | (37.7170816163747, -122.469021010071) | 9 | 8 | 6 | 64 | 24 | ||
| 173866 | 45326 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1385 Holloway Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2001 12:00:00 AM | Permit Number 44161 | 5991450.97971793 | 2091205.24216012 | 37.7215599710698 | -122.471645977425 | (37.7215599710698, -122.471645977425) | 9 | 8 | 6 | 64 | 24 | |||
| 174822 | 75386 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
| 179940 | 62390 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 259 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1985 12:00:00 AM | Permit Number 22540 | 6000848.37769972 | 2093515.20006186 | 37.7284418053746 | -122.439327280294 | (37.7284418053746, -122.439327280294) | 9 | 7 | 6 | 28861 | 25 | ||
| 184631 | 47495 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 222 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 10 | Permit Number 45388 | 6001706.9707 | 2093841.21109 | 37.7293857804089 | -122.436382409642 | (37.7293857804089, -122.436382409642) | 9 | 7 | 6 | 28861 | 25 | |
| 188557 | 231955 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 136 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004248.08815 | 2095120.37618 | 37.7330421432752 | -122.42768862922 | (37.7330421432752, -122.42768862922) | 9 | 7 | 5 | 28861 | 25 | |||
| 188615 | 68833 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 178 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32784 | 5999570.75659197 | 2094098.77581282 | 37.7299713792854 | -122.443785974037 | (37.7299713792854, -122.443785974037) | 9 | 7 | 4 | 63 | 40 | ||
| 192102 | 37860 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 147 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | 13 | 6x8 | Permit Number 40147 | 6003940.89934 | 2092950.10622 | 37.7270656869264 | -122.428596014613 | (37.7270656869264, -122.428596014613) | 9 | 7 | 6 | 28861 | 5 |
| 193722 | 77213 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 499X Hearst Ave | 20 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 8 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
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) );