Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1769 | 1769 | 251689 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 355 Silver Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003702.0 | 2093526.0 | 37.728633439635104 | -122.429462937782 | (37.7286334396351, -122.429462937782) | |||||
19238 | 19238 | 104509 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80 DICHIERA CT | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5998620.0 | 2088043.0 | 37.7132893442667 | -122.446637305723 | (37.7132893442667, -122.446637305723) | |||||
29641 | 29641 | 89003 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 658 40th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51755 | 5983531.7658 | 2111325.68873 | 37.7763438006114 | -122.50050706598 | (37.7763438006114, -122.50050706598) | ||
47993 | 47993 | 105254 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 130 GONZALEZ DR | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 5990327.0 | 2090136.0 | 37.7185590045312 | -122.47545320091999 | (37.7185590045312, -122.47545320092) | |||||
77391 | 77391 | 92760 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
78407 | 78407 | 92764 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
78600 | 78600 | 97647 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1844 Noriega St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988207.7 | 2103154.5 | 37.754181336878204 | -122.483732655057 | (37.7541813368782, -122.483732655057) | |||||
80131 | 80131 | 107758 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 126 HIGHLAND AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005605.1 | 2096623.0 | 37.7372446808015 | -122.42310384359101 | (37.7372446808015, -122.423103843591) | |||||
81002 | 81002 | 86871 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2160 Green St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49804 | 6002705.0 | 2118187.0 | 37.796290071465 | -122.43467232535102 | (37.796290071465, -122.434672325351) | ||||
82826 | 82826 | 92763 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
82954 | 82954 | 88643 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2285 Jerrold Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51616 | 6011739.6 | 2099623.0 | 37.745826311758705 | -122.40210478451701 | (37.7458263117587, -122.402104784517) | |||
83452 | 83452 | 92762 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
86127 | 86127 | 92761 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
96352 | 96352 | 92759 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
97665 | 97665 | 87752 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3738 Geary Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50409 | 5995374.6 | 2112966.7 | 37.7815376640386 | -122.459658564837 | (37.7815376640386, -122.459658564837) | |||
100079 | 100079 | 86747 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 211 Magellan Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49712 | 5995006.7 | 2100576.6 | 37.7474965017759 | -122.46003345468 | (37.7474965017759, -122.46003345468) | |||||
100575 | 100575 | 110968 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2411 WASHINGTON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x6 | 6003071.0 | 2116473.0 | 37.7916046396744 | -122.433283354559 | (37.7916046396744, -122.433283354559) | ||||
102016 | 102016 | 105368 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 180 CLIFFORD TER | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999283.1 | 2106587.2 | 37.7642451591147 | -122.44567816768298 | (37.7642451591147, -122.445678167683) | ||||||
109111 | 109111 | 88110 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1779 48th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51114 | 5981270.0 | 2102975.3 | 37.753283017346895 | -122.507711214113 | (37.7532830173469, -122.507711214113) | |||
113684 | 113684 | 92767 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
116515 | 116515 | 92766 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
117262 | 117262 | 86776 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 756 07th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49748 | 5993859.3 | 2110364.9 | 37.7743065681305 | -122.464711743298 | (37.7743065681305, -122.464711743298) | ||||
119238 | 119238 | 88276 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2374 47th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 3x3 | Permit Number 767123 | 5981803.3 | 2098936.1 | 37.7422239080831 | -122.505567596003 | (37.7422239080831, -122.505567596003) | ||
123122 | 123122 | 88103 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1246 45th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51107 | 5982161.5 | 2106610.6 | 37.763316999992 | -122.504897638357 | (37.763316999992, -122.504897638357) | |||
126264 | 126264 | 104551 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 428 PANORAMA DR | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5997536.0 | 2102327.0 | 37.7524478160364 | -122.451413569464 | (37.7524478160364, -122.451413569464) | ||||
126392 | 126392 | 111935 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 66 SEACLIFF AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 5987847.0 | 2115823.0 | 37.788944509176 | -122.485909838035 | (37.788944509176, -122.485909838035) | |||||
127045 | 127045 | 92765 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
128293 | 128293 | 89364 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2690 Ocean Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51942 | 5990665.5 | 2095192.3 | 37.732461956267294 | -122.474651985861 | (37.7324619562673, -122.474651985861) | ||||
128889 | 128889 | 104678 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3531-3535 16TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003359.0 | 2106442.3 | 37.7640791638998 | -122.431570451949 | (37.7640791638998, -122.431570451949) | ||||
138336 | 138336 | 106366 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 9 SEAL ROCK DR | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981833.1 | 2112945.4 | 37.7806911884837 | -122.506503269885 | (37.7806911884837, -122.506503269885) | ||||||
139491 | 139491 | 88644 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2285 Jerrold Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51616 | 6011739.6 | 2099623.0 | 37.745826311758705 | -122.40210478451701 | (37.7458263117587, -122.402104784517) | |||
141122 | 141122 | 89043 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2590X WASHINGTON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2008 12:00:00 AM | 3x3 | Permit Number 51782 | 6002311.0 | 2116492.0 | 37.791613664863206 | -122.435914302745 | (37.7916136648632, -122.435914302745) | |||
141957 | 141957 | 87821 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1359 45th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50714 | 5982101.5 | 2105852.2 | 37.7612311205066 | -122.50504894882401 | (37.7612311205066, -122.505048948824) | |||
142498 | 142498 | 88086 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1215 38th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51086 | 5984240.0 | 2106877.9 | 37.7641729917025 | -122.49772863665399 | (37.7641729917025, -122.497728636654) | |||
163671 | 163671 | 86769 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 574 26th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49742 | 5987849.115680001 | 2112068.76078 | 37.7786365594606 | -122.48562688470699 | (37.7786365594606, -122.485626884707) | ||
172500 | 172500 | 87843 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2630 Balboa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50750 | 5987373.4413 | 2111210.00653 | 37.7762509357291 | -122.487209313782 | (37.7762509357291, -122.487209313782) | ||
2 | 2 | 232565 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 940 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/20/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779625 | 6000396.48544 | 2101998.8644 | 37.7517102172731 | -122.441498017841 | (37.7517102172731, -122.441498017841) | |
88 | 88 | 251208 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4115 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5982071.0 | 2104840.0 | 37.758450113202294 | -122.505079418654 | (37.7584501132023, -122.505079418654) | ||||
110 | 110 | 97646 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1824 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5988290.0 | 2103126.0 | 37.7541078738982 | -122.48344595561899 | (37.7541078738982, -122.483445955619) | |||
121 | 121 | 59839 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1201 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1981 12:00:00 AM | 3 | Permit Number 19293 | 6016946.5018 | 2093669.1216 | 37.729767407645895 | -122.383685429115 | (37.7297674076459, -122.383685429115) | |
140 | 140 | 6337 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1916 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001700.9234 | 2112915.307 | 37.7817583075946 | -122.437768878541 | (37.7817583075946, -122.437768878541) | |||
173 | 173 | 175044 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80x Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 3ft | 5991568.948890001 | 2087568.2224599998 | 37.7115804269636 | -122.470973377029 | (37.7115804269636, -122.470973377029) | |||
218 | 218 | 11423 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 722X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 3X3 | 6016169.292972799 | 2097000.9113916 | 37.738872842648796 | -122.38660458641 | (37.7388728426488, -122.38660458641) | |||
275 | 275 | 818 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1385 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 5982124.8821 | 2105687.3873 | 37.7607799675436 | -122.504955867812 | (37.7607799675436, -122.504955867812) | |||
441 | 441 | 251295 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 220 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1989 12:00:00 AM | 3x3 | Permit Number 27117 | 5982087.0 | 2112698.0 | 37.7800268469822 | -122.50560657808902 | (37.7800268469822, -122.505606578089) | ||
802 | 802 | 64866 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1989 12:00:00 AM | 13 | Permit Number 25884 | 5997401.9097 | 2109840.7512 | 37.773070992957 | -122.45241943675501 | (37.773070992957, -122.452419436755) | |
848 | 848 | 2190 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1055 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000864.0909 | 2112351.4116 | 37.7801623757286 | -122.44062346036199 | (37.7801623757286, -122.440623460362) | |||
872 | 872 | 5299 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6001101.8528 | 2114070.3216 | 37.7848955998057 | -122.43992421757 | (37.7848955998057, -122.43992421757) | |||
1071 | 1071 | 177641 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5900 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | Width 4ft | 5996637.80016 | 2086397.8441299999 | 37.708658698704795 | -122.45336973165199 | (37.7086586987048, -122.453369731652) | |||
1114 | 1114 | 232676 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 73 Montezuma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x5 | 6007815.58423 | 2099781.3356 | 37.7460412642866 | -122.41568472316901 | (37.7460412642866, -122.415684723169) | |||
1141 | 1141 | 251461 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6400 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/01/1993 12:00:00 AM | 3x3 | 5987191.0 | 2112582.0 | 37.7800074013317 | -122.48794125088699 | (37.7800074013317, -122.487941250887) | |||
1245 | 1245 | 6073 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1944 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001125.2679 | 2112488.2186 | 37.7805528822601 | -122.439729742976 | (37.7805528822601, -122.439729742976) | |||
1426 | 1426 | 5257 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1199 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001336.2739 | 2112445.4083 | 37.780447344039395 | -122.43899670569701 | (37.7804473440394, -122.438996705697) | |||
1437 | 1437 | 111252 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3129x Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5983208.5024 | 2097401.5189 | 37.7380929647396 | -122.500595473335 | (37.7380929647396, -122.500595473335) | |||
1442 | 1442 | 111247 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3101x Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x4 | 5983327.0508 | 2097406.6113 | 37.738113905777794 | -122.500185975345 | (37.7381139057778, -122.500185975345) | |||
1490 | 1490 | 8186 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1247 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001773.6755 | 2111139.4897 | 37.7768864982616 | -122.437389990835 | (37.7768864982616, -122.437389990835) | |||
1542 | 1542 | 6967 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 720 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003956.4801 | 2110455.6856 | 37.7751327920886 | -122.42979022245899 | (37.7751327920886, -122.429790222459) | |||
1564 | 1564 | 106910 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3536 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773298 | 5997359.139830001 | 2116076.9553400003 | 37.7901915187728 | -122.453017625461 | (37.7901915187728, -122.453017625461) | |
1606 | 1606 | 8736 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3240 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/1986 12:00:00 AM | 3 | 3X3 | 5997038.8246 | 2113016.8335 | 37.781770875875004 | -122.45390479883801 | (37.781770875875, -122.453904798838) | ||
1900 | 1900 | 8769 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3416 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1992 12:00:00 AM | 3 | 3X3 | 5996444.0483 | 2112944.9189 | 37.78153929807 | -122.455957233363 | (37.78153929807, -122.455957233363) | ||
2073 | 2073 | 252864 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1660 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000023.0 | 2106990.0 | 37.7653933634599 | -122.443148003218 | (37.7653933634599, -122.443148003218) | ||||
2136 | 2136 | 24780 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 25 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 5982810.69991 | 2112498.67348 | 37.779522119266204 | -122.503088254558 | (37.7795221192662, -122.503088254558) | |||
2153 | 2153 | 251201 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | ||
2451 | 2451 | 2187 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1040 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6000917.5615 | 2112301.3252 | 37.7800278959817 | -122.440434888409 | (37.7800278959817, -122.440434888409) | |||
2475 | 2475 | 213240 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 72 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 11/24/1982 12:00:00 AM | 14 | Width 3ft | Permit Number 20046 | 5997197.846969999 | 2089560.74227 | 37.7173753740534 | -122.451662146612 | (37.7173753740534, -122.451662146612) | |
2599 | 2599 | 56658 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2436 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5987881.10051 | 2113316.56801 | 37.7820645490157 | -122.485607837735 | (37.7820645490157, -122.485607837735) | ||||
2672 | 2672 | 183250 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2107 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984200.2859 | 2100804.8827 | 37.7474958486327 | -122.497417620086 | (37.7474958486327, -122.497417620086) | |
2755 | 2755 | 2701 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2121 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003174.2357 | 2114805.7903 | 37.787032762464705 | -122.432807006492 | (37.7870327624647, -122.432807006492) | |||
2808 | 2808 | 232604 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 509 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1989 12:00:00 AM | 14 | Width 3ft | Permit Number 28219 | 6003467.96193 | 2095980.6299 | 37.7353600451305 | -122.430447088284 | (37.7353600451305, -122.430447088284) | |
2832 | 2832 | 232603 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 519 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1989 12:00:00 AM | 15 | Width 3ft | Permit Number 28180 | 6003417.91848 | 2095942.05224 | 37.7352512847143 | -122.430617355104 | (37.7352512847143, -122.430617355104) | |
2845 | 2845 | 2651 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1958 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004155.6542 | 2114999.6285 | 37.787620606441294 | -122.429425346374 | (37.7876206064413, -122.429425346374) | |||
2851 | 2851 | 18919 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2645 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002161.66396 | 2115714.10413 | 37.7894692786198 | -122.43637530499201 | (37.7894692786198, -122.436375304992) | |||
2870 | 2870 | 2203 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1120 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 7x5 | 6000884.7346 | 2112533.821 | 37.780664400973 | -122.440565131493 | (37.780664400973, -122.440565131493) | |||
2934 | 2934 | 250407 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 25 Seacliff Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/16/1997 12:00:00 AM | 12 | Width 4ft | Permit Number 38521 | 5987994.17396 | 2115794.4903599997 | 37.78887480516529 | -122.485398549405 | (37.7888748051653, -122.485398549405) | |
2955 | 2955 | 232230 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 111 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 7 | Width 3ft | Permit Number 37780 | 6003632.85461 | 2108809.4147799998 | 37.7705942049744 | -122.430792205812 | (37.7705942049744, -122.430792205812) | |
2967 | 2967 | 90257 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3230 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5985539.08481 | 2111145.48476 | 37.775966641531504 | -122.49355000935199 | (37.7759666415315, -122.493550009352) | ||
2983 | 2983 | 250419 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | 8 | Width 4ft | Permit Number 38081 | 5987849.1846199995 | 2115791.00757 | 37.7888567944531 | -122.48589993045601 | (37.7888567944531, -122.485899930456) | |
3089 | 3089 | 2184 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1030 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6000920.2689 | 2112277.9741 | 37.779963933965995 | -122.440423847121 | (37.779963933966, -122.440423847121) | |||
3157 | 3157 | 6076 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1950 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001110.3773 | 2112486.1881 | 37.780546459454996 | -122.439781110889 | (37.780546459455, -122.439781110889) | |||
3167 | 3167 | 210018 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 129 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 10 | Width 3ft | Permit Number 25335 | 5995846.58682 | 2096221.4645200002 | 37.7355866437016 | -122.45681426186701 | (37.7355866437016, -122.456814261867) | |
3175 | 3175 | 10515 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1801 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/2017 12:00:00 AM | 3 | 3X3 | 5997497.7686 | 2108463.8393 | 37.7692958388006 | -122.451988492124 | (37.7692958388006, -122.451988492124) | ||
3177 | 3177 | 46976 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 94122 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44996 | ||||||||
3232 | 3232 | 253369 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 449X Trumbull St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | Width 10ft | 6005840.0 | 2094317.0 | 37.730926169648 | -122.42212790794599 | (37.730926169648, -122.422127907946) | ||||
3314 | 3314 | 8704 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3040 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997630.7244 | 2113099.07 | 37.7820305944204 | -122.45186304771099 | (37.7820305944204, -122.451863047711) | |||
3381 | 3381 | 8153 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1052 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6002732.6953 | 2111326.1234 | 37.777453421805895 | -122.434085798199 | (37.7774534218059, -122.434085798199) | |||
3470 | 3470 | 8669 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5998067.7961 | 2113159.1399 | 37.7822205542064 | -122.450355317805 | (37.7822205542064, -122.450355317805) | |||
3476 | 3476 | 8169 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1178 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6002155.3413 | 2111245.817 | 37.7772001368339 | -122.436077305312 | (37.7772001368339, -122.436077305312) | |||
3477 | 3477 | 22794 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1015X Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6000886.4267 | 2112199.4602 | 37.7797464277805 | -122.440535289267 | (37.7797464277805, -122.440535289267) | |||
3635 | 3635 | 210326 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1515 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1992 12:00:00 AM | 6 | Width 2ft | Permit Number 31364 | 5994586.35542 | 2105191.7373900004 | 37.760144306721 | -122.46182156022499 | (37.760144306721, -122.461821560225) | |
3659 | 3659 | 209947 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2400 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 13 | Width 3ft | Permit Number 35554 | 5992051.55672 | 2099045.56782 | 37.7431222717841 | -122.47014058862301 | (37.7431222717841, -122.470140588623) | |
3734 | 3734 | 118035 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 4ft | 5984123.0 | 2112760.0 | 37.7803166927985 | -122.498567828267 | (37.7803166927985, -122.498567828267) | |||
3847 | 3847 | 246106 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1899 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997112.57 | 2108409.6329 | 37.769124930744795 | -122.453316953855 | (37.7691249307448, -122.453316953855) | |||
3848 | 3848 | 131894 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1902 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 5999986.70949 | 2115482.27208 | 37.788708906339295 | -122.443883720452 | (37.7887089063393, -122.443883720452) | |||
3866 | 3866 | 253581 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
3867 | 3867 | 253577 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
3911 | 3911 | 11896 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 603 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/04/2017 12:00:00 AM | 3 | 3x3 | 6017299.30184 | 2096353.9074400002 | 37.7371587926313 | -122.382652493121 | (37.7371587926313, -122.382652493121) | ||
4170 | 4170 | 6079 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1968 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001023.7414 | 2112472.9897 | 37.780505288271705 | -122.44007987815701 | (37.7805052882717, -122.440079878157) | |||
4225 | 4225 | 6366 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2072 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000952.842 | 2112811.2423 | 37.7814300071208 | -122.44034941736601 | (37.7814300071208, -122.440349417366) | |||
4275 | 4275 | 24939 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7315 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 10:40:00 AM | 3 | 3X3 | 5984290.37601 | 2112411.90952 | 37.7793707517194 | -122.497963093664 | (37.7793707517194, -122.497963093664) | ||
4323 | 4323 | 5070 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5549 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001778.0 | 2097299.0 | 37.738884107486 | -122.43638423012699 | (37.738884107486, -122.436384230127) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");