trees
979 rows where qSpecies_id = 13 sorted by YCoord descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189398 | 130985 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2098 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999249.25927 | 2121180.66389 | 37.8043130782603 | -122.446845381305 | (37.8043130782603, -122.446845381305) | 13 | 9 | 1 | 57 | 17 | |||
33704 | 249813 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 260 Chestnut St | 3 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6010621.11973 | 2121031.89357 | 37.8045476726861 | -122.407481446514 | (37.8045476726861, -122.407481446514) | 3 | 1 | 10 | 308 | 23 | |||
54020 | 95101 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3601x Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 2 | 5999657.71874 | 2120941.08267 | 37.8036785786574 | -122.445414641767 | (37.8036785786574, -122.445414641767) | 13 | 9 | 1 | 57 | 17 | |||
130421 | 130982 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3601 Broderick St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5999659.44076 | 2120919.32346 | 37.8036189320344 | -122.445407117147 | (37.8036189320344, -122.445407117147) | 13 | 9 | 1 | 57 | 17 | |||
24065 | 95100 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773992 | 5999642.14759 | 2120895.84862 | 37.8035534892505 | -122.445465271815 | (37.8035534892505, -122.445465271815) | 13 | 9 | 1 | 57 | 17 | |
148719 | 95104 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 5 | 5999633.73017 | 2120895.6152 | 37.8035523678131 | -122.445494383786 | (37.8035523678131, -122.445494383786) | 13 | 9 | 1 | 57 | 17 | |||
149568 | 95105 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 2 | 5999611.30639 | 2120892.81198 | 37.8035433907753 | -122.445571780333 | (37.8035433907753, -122.445571780333) | 13 | 9 | 1 | 57 | 17 | |||
123980 | 95129 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200@Broderick Beach St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 5999690 | 2120891 | 37.8035429078816 | -122.445299328106 | (37.8035429078816, -122.445299328106) | 13 | 9 | 1 | 57 | 17 | ||||
82405 | 130983 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 5999604.29073 | 2120890.91469 | 37.8035377808009 | -122.44559592174 | (37.8035377808009, -122.44559592174) | 13 | 9 | 1 | 57 | 17 | |||
50977 | 130984 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 5999592.95513 | 2120888.49408 | 37.803530487293 | -122.445634974783 | (37.803530487293, -122.445634974783) | 13 | 9 | 1 | 57 | 17 | |||
107450 | 4378 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2425X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6006994.61601 | 2120672.53629 | 37.8033573165358 | -122.420005806422 | (37.8033573165358, -122.420005806422) | 5 | 1 | 1 | 28858 | 32 | |||
5427 | 146424 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2131 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6000557.07663 | 2120624.21431 | 37.8028598421591 | -122.442279615007 | (37.8028598421591, -122.442279615007) | 13 | 9 | 1 | 57 | 17 | |||
45229 | 13059 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 583 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:23:00 AM | 3 | 2x2 | 6009557.0524 | 2120495.5376 | 37.8030153566132 | -122.41112585507 | (37.8030153566132, -122.41112585507) | 3 | 1 | 10 | 308 | 23 | ||
16255 | 130986 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3147 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004613.79741 | 2120397.19916 | 37.8024668888085 | -122.428225084716 | (37.8024668888085, -122.428225084716) | 13 | 9 | 1 | 57 | 17 | |||
11453 | 130994 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 800 Lombard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008432.69085 | 2120383.1883 | 37.8026437557674 | -122.415008787324 | (37.8026437557674, -122.415008787324) | 5 | 1 | 10 | 308 | 32 | |||
71703 | 130995 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 832 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008337.45548 | 2120371.32318 | 37.8026058250595 | -122.41533751024 | (37.8026058250595, -122.41533751024) | 5 | 1 | 10 | 308 | 32 | |||
104120 | 131002 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 937 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/09/2014 12:00:00 AM | 2 | Width 3ft | 6007919.06293 | 2120264.13988 | 37.8022880028424 | -122.416777764577 | (37.8022880028424, -122.416777764577) | 5 | 1 | 10 | 308 | 32 | ||
102454 | 131001 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 937 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | Width 3ft | 6007906.15602 | 2120261.72441 | 37.8022806446072 | -122.416822257668 | (37.8022806446072, -122.416822257668) | 5 | 1 | 10 | 308 | 32 | |||
18076 | 131000 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 937 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/09/2014 12:00:00 AM | 2 | Width 3ft | 6007889.3393 | 2120258.19812 | 37.8022700164033 | -122.416880201885 | (37.8022700164033, -122.416880201885) | 5 | 1 | 10 | 308 | 32 | ||
97084 | 250221 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 312 Filbert St | 2 | Side Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011282.00764 | 2120080.85256 | 37.8019733165766 | -122.405127362244 | (37.8019733165766, -122.405127362244) | 3 | 1 | 10 | 308 | 23 | |||
111243 | 66134 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3259 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2011 12:00:00 AM | 3 | Permit Number 768243 | 5999299.78945 | 2120070.84719 | 37.8012687076388 | -122.446590621369 | (37.8012687076388, -122.446590621369) | 13 | 9 | 1 | 57 | 17 | ||
181538 | 87076 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2565 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50014 | 6006601.66741 | 2120051.34913 | 37.8016295480248 | -122.421321483111 | (37.8016295480248, -122.421321483111) | 5 | 9 | 1 | 28858 | 32 | |
96748 | 249953 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 303 Filbert St | 2 | Side Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011372.65237 | 2120041.55492 | 37.8018704817969 | -122.404810918689 | (37.8018704817969, -122.404810918689) | 3 | 1 | 10 | 308 | 23 | |||
74008 | 249952 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 303 Filbert St | 3 | Side Yard : Yard | Tree | Private 2 | 2 | Width 0ft | 6011371.46837 | 2120040.8031 | 37.8018683513038 | -122.404814962944 | (37.8018683513038, -122.404814962944) | 3 | 1 | 10 | 308 | 23 | |||
99113 | 87077 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2565 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50014 | 6006603.98041 | 2120038.08601 | 37.8015932612686 | -122.421312536668 | (37.8015932612686, -122.421312536668) | 5 | 9 | 1 | 28858 | 32 | |
93475 | 249954 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 303 Filbert St | 1 | Side Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011374.5207 | 2120037.63727 | 37.8018598293151 | -122.404804177386 | (37.8018598293151, -122.404804177386) | 3 | 1 | 10 | 308 | 23 | |||
176927 | 130997 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Leavenworth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007578.93915 | 2119952.78886 | 37.8014139751467 | -122.417932677574 | (37.8014139751467, -122.417932677574) | 5 | 1 | 1 | 28858 | 32 | |||
24814 | 130998 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Leavenworth St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007580.24685 | 2119942.9983 | 37.8013871663302 | -122.417927457909 | (37.8013871663302, -122.417927457909) | 5 | 1 | 1 | 28858 | 32 | |||
49090 | 51497 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 741 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50950 | 6009247.81044 | 2119754.33215 | 37.8009628437188 | -122.412143582356 | (37.8009628437188, -122.412143582356) | 3 | 1 | 10 | 308 | 4 | |
133316 | 130999 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2009 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008124.35834 | 2119571.24818 | 37.8003970406522 | -122.416018243071 | (37.8003970406522, -122.416018243071) | 5 | 1 | 1 | 308 | 32 | |||
54419 | 131003 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1109 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011959.67514 | 2119544.33527 | 37.8005380309676 | -122.402744545519 | (37.8005380309676, -122.402744545519) | 3 | 1 | 10 | 308 | 23 | |||
112413 | 131004 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1109 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011962.57681 | 2119524.82057 | 37.8004846103385 | -122.402733131341 | (37.8004846103385, -122.402733131341) | 3 | 1 | 10 | 308 | 23 | |||
108983 | 131005 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1109 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011966.28047 | 2119507.31076 | 37.8004367394276 | -122.40271908303 | (37.8004367394276, -122.40271908303) | 3 | 1 | 10 | 308 | 23 | |||
3356 | 74692 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 200 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011876.44918 | 2119465.43765 | 37.8003167500634 | -122.403026990216 | (37.8003167500634, -122.403026990216) | 3 | 1 | 10 | 308 | 23 | |||
184962 | 130966 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99 Moulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002966.56472 | 2119407.57255 | 37.7996562924699 | -122.433854543963 | (37.7996562924699, -122.433854543963) | 13 | 9 | 1 | 57 | 17 | |||
188688 | 13238 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2322 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1998 12:00:00 AM | 3 | 3X3 | 6001219.43305 | 2119376.81704 | 37.7994725475626 | -122.439898035919 | (37.7994725475626, -122.439898035919) | 13 | 9 | 1 | 57 | 17 | ||
16680 | 256664 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1381 Filbert St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 5x5 | Permit Number 782595 | 6006338.70929 | 2119347.35531 | 37.7996817310416 | -122.422181395696 | (37.7996817310416, -122.422181395696) | 13 | 9 | 1 | 28858 | 32 | |
23388 | 256663 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1381 Filbert St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782595 | 6006338.70929 | 2119347.35531 | 37.7996817310416 | -122.422181395696 | (37.7996817310416, -122.422181395696) | 13 | 9 | 1 | 28858 | 32 | |
145251 | 108356 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002158.91155 | 2118972.60439 | 37.7984161192732 | -122.436618162405 | (37.7984161192732, -122.436618162405) | 13 | 9 | 1 | 57 | 17 | |
108505 | 108357 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002140.21513 | 2118970.44706 | 37.7984091333207 | -122.436682703142 | (37.7984091333207, -122.436682703142) | 13 | 9 | 1 | 57 | 17 | |
177003 | 108358 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002123.02459 | 2118966.98612 | 37.7983986535418 | -122.436741939704 | (37.7983986535418, -122.436741939704) | 13 | 9 | 1 | 57 | 17 | |
103481 | 127870 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1863 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782589 | 6007272.90865 | 2118759.36484 | 37.798119905069 | -122.418906991373 | (37.798119905069, -122.418906991373) | 5 | 1 | 10 | 28858 | 32 |
148842 | 104140 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2301X Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2013 12:00:00 AM | 3x3 | Permit Number 770728 | 6001711.91514 | 2118723.596 | 37.7977069957146 | -122.438147056882 | (37.7977069957146, -122.438147056882) | 13 | 9 | 1 | 57 | 17 | ||
154327 | 104139 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2301X Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2013 12:00:00 AM | 3x3 | Permit Number 770728 | 6001711.91514 | 2118723.596 | 37.7977069957146 | -122.438147056882 | (37.7977069957146, -122.438147056882) | 13 | 9 | 1 | 57 | 17 | ||
26823 | 130979 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3001 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003392.63825 | 2118710.53887 | 37.7977665875245 | -122.432330365752 | (37.7977665875245, -122.432330365752) | 13 | 9 | 1 | 57 | 17 | |||
94413 | 104138 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3067 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2013 12:00:00 AM | 3x3 | Permit Number 770728 | 6001906.1 | 2118706.9 | 37.7976721947069 | -122.437473929103 | (37.7976721947069, -122.437473929103) | 13 | 9 | 1 | 57 | 17 | ||
54645 | 130980 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3001 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003394.29695 | 2118690.35312 | 37.797711256726 | -122.43232318378 | (37.797711256726, -122.43232318378) | 13 | 9 | 1 | 57 | 17 | |||
175599 | 130981 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3001 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6003397.35892 | 2118675.30556 | 37.7976701136348 | -122.432311513284 | (37.7976701136348, -122.432311513284) | 13 | 9 | 1 | 57 | 17 | |||
8309 | 55891 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1981 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/1979 12:00:00 AM | 4 | Permit Number 17936 | 6003525.54431 | 2118603.6465 | 37.7974806237872 | -122.431862837898 | (37.7974806237872, -122.431862837898) | 13 | 9 | 1 | 57 | 17 | ||
79934 | 106843 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1869 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2014 12:00:00 AM | Permit Number 773317 | 6004088.44172 | 2118602.99638 | 37.7975107321666 | -122.429915018594 | (37.7975107321666, -122.429915018594) | 13 | 9 | 1 | 57 | 17 | |||
46000 | 130996 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 48 Bonita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6006123.48756 | 2118486.00095 | 37.7973045284306 | -122.422864892409 | (37.7973045284306, -122.422864892409) | 13 | 9 | 10 | 28858 | 32 | |||
191056 | 130970 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6002945.56276 | 2118345.79466 | 37.796739734404 | -122.433851284829 | (37.796739734404, -122.433851284829) | 13 | 9 | 1 | 57 | 17 | |||
188023 | 130971 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6002947.99505 | 2118332.47012 | 37.7967032866916 | -122.43384191569 | (37.7967032866916, -122.43384191569) | 13 | 9 | 1 | 57 | 17 | |||
91579 | 130972 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6002950.18497 | 2118317.4913 | 37.7966622830002 | -122.433833266913 | (37.7966622830002, -122.433833266913) | 13 | 9 | 1 | 57 | 17 | |||
142173 | 130973 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6002952.36205 | 2118301.89076 | 37.7966195714971 | -122.433824618115 | (37.7966195714971, -122.433824618115) | 13 | 9 | 1 | 57 | 17 | |||
85985 | 130974 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 2ft | 6002954.53886 | 2118286.2899 | 37.7965768590991 | -122.433815970239 | (37.7965768590991, -122.433815970239) | 13 | 9 | 1 | 57 | 17 | |||
59767 | 130975 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6002956.23707 | 2118277.75105 | 37.796553509993 | -122.433809483441 | (37.796553509993, -122.433809483441) | 13 | 9 | 1 | 57 | 17 | |||
71387 | 130976 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6002956.82977 | 2118266.12381 | 37.796521618235 | -122.433806601098 | (37.796521618235, -122.433806601098) | 13 | 9 | 1 | 57 | 17 | |||
82925 | 130977 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 2ft | 6002958.54941 | 2118258.62149 | 37.7965011163873 | -122.433800114279 | (37.7965011163873, -122.433800114279) | 13 | 9 | 1 | 57 | 17 | |||
142516 | 130978 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2801 Webster St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6002959.93216 | 2118244.90398 | 37.7964635301195 | -122.433794348725 | (37.7964635301195, -122.433794348725) | 13 | 9 | 1 | 57 | 17 | |||
159186 | 34926 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2625 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2012 12:00:00 AM | 4 | Permit Number 768761 | 5999600.82758 | 2117890.72086 | 37.7952998532682 | -122.445392054402 | (37.7952998532682, -122.445392054402) | 13 | 9 | 1 | 57 | 17 | ||
153558 | 34927 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2625 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2012 12:00:00 AM | 3 | Permit Number 768761 | 5999601.94789 | 2117876.97454 | 37.7952621734732 | -122.445387189083 | (37.7952621734732, -122.445387189083) | 13 | 9 | 1 | 57 | 17 | ||
64815 | 97108 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1472 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/12/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768373 | 6007110.85897 | 2117762.02293 | 37.795372327823 | -122.419396941128 | (37.795372327823, -122.419396941128) | 5 | 1 | 10 | 28858 | 32 |
68819 | 131009 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 4 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013684.35472 | 2117443.22893 | 37.7948650355324 | -122.396629040522 | (37.7948650355324, -122.396629040522) | 4 | 1 | 10 | 28860 | 6 | |||
3991 | 131008 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 3 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013685.84477 | 2117434.71438 | 37.7948417395127 | -122.396623287539 | (37.7948417395127, -122.396623287539) | 4 | 1 | 10 | 28860 | 6 | |||
34619 | 131007 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 2 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013687.07221 | 2117423.51513 | 37.7948110573238 | -122.396618254944 | (37.7948110573238, -122.396618254944) | 4 | 1 | 10 | 28860 | 6 | |||
27090 | 130990 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1465 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007716.27446 | 2117147.85171 | 37.7937200456874 | -122.417258554752 | (37.7937200456874, -122.417258554752) | 5 | 1 | 10 | 28858 | 32 | |||
135376 | 88424 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1465 Washington St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51388 | 6007689 | 2117147 | 37.7937161726159 | -122.417352866644 | (37.7937161726159, -122.417352866644) | 5 | 1 | 10 | 28858 | 32 | |||
131626 | 84840 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1107 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2007 12:00:00 AM | 7 | Permit No. 49267 | 6009440.82091 | 2117125.31431 | 37.7937550347318 | -122.411289855968 | (37.7937550347318, -122.411289855968) | 3 | 1 | 10 | 28857 | 21 | ||
175085 | 89299 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2825 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2008 12:00:00 AM | 3x3 | Permit Number 51902 | 6000069.8 | 2117048.2 | 37.7930132732955 | -122.443708782466 | (37.7930132732955, -122.443708782466) | 13 | 6 | 1 | 29490 | 27 | ||
101178 | 130993 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1645 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006795.77998 | 2117016.02483 | 37.7933062523213 | -122.4204341913 | (37.7933062523213, -122.4204341913) | 13 | 9 | 10 | 28858 | 32 | |||
114265 | 130992 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1645 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006789.62412 | 2117015.0975 | 37.7933033592027 | -122.420455425186 | (37.7933033592027, -122.420455425186) | 13 | 9 | 10 | 28858 | 32 | |||
49967 | 130991 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1645 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006783.4642 | 2117013.95966 | 37.7932998878436 | -122.420476658169 | (37.7932998878436, -122.420476658169) | 13 | 9 | 10 | 28858 | 32 | |||
191835 | 136108 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2160 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782573 | 6005089.07981 | 2116957.29381 | 37.7930486667182 | -122.426335311432 | (37.7930486667182, -122.426335311432) | 13 | 9 | 1 | 28858 | 27 | |
139673 | 127383 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2160 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782573 | 6005103.8437 | 2116881.77559 | 37.792842147287 | -122.426278848408 | (37.792842147287, -122.426278848408) | 13 | 9 | 1 | 28858 | 27 | |
94680 | 132274 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2160 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782573 | 6005107.40746 | 2116851.05926 | 37.7927580094371 | -122.426264329748 | (37.7927580094371, -122.426264329748) | 13 | 9 | 1 | 28858 | 27 | |
146912 | 125204 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2000 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782573 | 6005093.29974 | 2116822.56414 | 37.7926789715987 | -122.426311113392 | (37.7926789715987, -122.426311113392) | 13 | 9 | 1 | 28858 | 27 | |
150499 | 88037 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2301X Lyon St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51052 | 5999275.57165 | 2116691.87228 | 37.7919895603315 | -122.446431199448 | (37.7919895603315, -122.446431199448) | 11 | 6 | 1 | 29490 | 30 | |
9218 | 106080 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 188 The Embarcadero | 1 | Front Yard : Yard | Tree | Private 2 | 03/20/2014 12:00:00 AM | Permit Number 771259 | 6015087.8131 | 2116516.98611 | 37.7923997963133 | -122.391708043282 | (37.7923997963133, -122.391708043282) | 12 | 2 | 9 | 28855 | 6 | |||
67172 | 193355 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 60 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013990.6766 | 2116456.52969 | 37.7921728340575 | -122.395499955167 | (37.7921728340575, -122.395499955167) | 12 | 2 | 9 | 28855 | 6 | |||
147690 | 193356 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 60 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014000.33626 | 2116445.25726 | 37.7921424198756 | -122.395465742269 | (37.7921424198756, -122.395465742269) | 12 | 2 | 9 | 28855 | 6 | |||
103563 | 193357 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 62 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014010.13309 | 2116432.89008 | 37.7921090073852 | -122.395430978058 | (37.7921090073852, -122.395430978058) | 12 | 2 | 9 | 28855 | 6 | |||
170760 | 193358 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 62 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014021.3474 | 2116423.46881 | 37.7920837625026 | -122.395391515812 | (37.7920837625026, -122.395391515812) | 12 | 2 | 9 | 28855 | 6 | |||
163418 | 113661 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3060 JACKSON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 5x5 | Permit Number 776720 | 5999534 | 2116404 | 37.7912138957856 | -122.445516329339 | (37.7912138957856, -122.445516329339) | 13 | 6 | 1 | 29490 | 27 | ||
2825 | 92602 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Baker St | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | ||
27502 | 92600 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Baker St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | ||
76365 | 92601 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Baker St | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | ||
127103 | 92603 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Baker St | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | ||
140052 | 92604 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Baker St | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | ||
185410 | 112790 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Joice St | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 11 | 3x3 | 6010307.81813 | 2116296.03331 | 37.7915266163113 | -122.408231437935 | (37.7915266163113, -122.408231437935) | 5 | 1 | 10 | 28857 | 21 | |||
84305 | 131006 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 25 Joice St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010297.06637 | 2116294.60935 | 37.7915221044126 | -122.408268538566 | (37.7915221044126, -122.408268538566) | 5 | 1 | 10 | 28857 | 21 | |||
154921 | 193359 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 208 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014052.91282 | 2116289.57894 | 37.7917178877279 | -122.395272915033 | (37.7917178877279, -122.395272915033) | 12 | 2 | 9 | 28855 | 6 | |||
183737 | 193360 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 208 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014042.14131 | 2116274.34783 | 37.7916754675957 | -122.395309117238 | (37.7916754675957, -122.395309117238) | 12 | 2 | 9 | 28855 | 6 | |||
134523 | 193361 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 246 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014025.95999 | 2116259.22664 | 37.7916330483898 | -122.395364045136 | (37.7916330483898, -122.395364045136) | 12 | 2 | 9 | 28855 | 6 | |||
27143 | 193373 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013783.27133 | 2116255.65231 | 37.7916097334637 | -122.396203501097 | (37.7916097334637, -122.396203501097) | 12 | 2 | 9 | 28855 | 6 | |||
95844 | 193362 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 246 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014011.61838 | 2116245.86436 | 37.7915955610366 | -122.395412730824 | (37.7915955610366, -122.395412730824) | 12 | 2 | 9 | 28855 | 6 | |||
110549 | 193372 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013792.54079 | 2116244.01793 | 37.7915783039417 | -122.39617061289 | (37.7915783039417, -122.39617061289) | 12 | 2 | 9 | 28855 | 6 | |||
131934 | 193363 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 246 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014000.9996 | 2116238.17517 | 37.7915738577077 | -122.395448933038 | (37.7915738577077, -122.395448933038) | 12 | 2 | 9 | 28855 | 6 | |||
169485 | 33779 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013803.37475 | 2116233.23226 | 37.7915492918181 | -122.396132371028 | (37.7915492918181, -122.396132371028) | 12 | 2 | 9 | 28855 | 6 | |
145435 | 193364 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 260 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013990.63933 | 2116225.45086 | 37.7915383434816 | -122.395483887876 | (37.7915383434816, -122.395483887876) | 12 | 2 | 9 | 28855 | 6 |
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) );