trees
953 rows where qSpecies_id = 60 sorted by Location 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44825 | 52659 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 501@ SCOTT Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | 8 | Permit Number 48739 | 6000536.81736 | 2121641.57816 | 37.8056520959413 | -122.44242280509 | (37.8056520959413, -122.44242280509) | 13 | 9 | 1 | 57 | 17 | ||
98772 | 66797 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2655 Polk St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 11/26/2018 12:00:00 AM | 3 | Permit Number 782624 | 6006123.61383 | 2119959.43623 | 37.8013502149967 | -122.422969232649 | (37.8013502149967, -122.422969232649) | 13 | 9 | 1 | 28858 | 32 | |
75078 | 125881 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2101 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001760.22052 | 2119747.88013 | 37.8005221579273 | -122.438053316704 | (37.8005221579273, -122.438053316704) | 13 | 9 | 1 | 57 | 17 | |||
120590 | 13142 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1799 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 70 | 3X3 | 6003833.3629 | 2119660.0062 | 37.8003985594643 | -122.43087313242 | (37.8003985594643, -122.43087313242) | 13 | 9 | 1 | 57 | 17 | ||
175825 | 125890 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 8 Sharp Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007493.35542 | 2119123.01732 | 37.7991308141058 | -122.418169974478 | (37.7991308141058, -122.418169974478) | 5 | 1 | 10 | 28858 | 32 | |||
72634 | 104807 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2069 GREEN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003141.4 | 2118171.7 | 37.7962728265697 | -122.433161198258 | (37.7962728265697, -122.433161198258) | 13 | 9 | 1 | 57 | 17 | ||||||
103431 | 52815 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2760 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773616 | 6000112.35725 | 2118047.78661 | 37.7957603016641 | -122.44363337349 | (37.7957603016641, -122.44363337349) | 13 | 9 | 1 | 57 | 17 | |
118525 | 125882 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2100 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005138.85638 | 2116964.61432 | 37.7930715805281 | -122.426163602963 | (37.7930715805281, -122.426163602963) | 13 | 9 | 1 | 28858 | 27 | |||
56301 | 33288 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1242 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 7 | Permit Number 37449 | 6008832.98278 | 2116682.76958 | 37.7925058062477 | -122.413361726687 | (37.7925058062477, -122.413361726687) | 5 | 1 | 10 | 28857 | 21 | |
23186 | 103507 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
44956 | 103510 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
83367 | 103511 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
143719 | 103509 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
160338 | 103508 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
56102 | 52371 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 970JONES Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48503 | 6008855.4568 | 2115649.67517 | 37.7896704425982 | -122.413210878899 | (37.7896704425982, -122.413210878899) | 5 | 1 | 10 | 28858 | 21 |
422 | 113225 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 970JONES Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | 6008828.65356 | 2115644.68399 | 37.7896552332384 | -122.413303262628 | (37.7896552332384, -122.413303262628) | 5 | 1 | 10 | 28858 | 21 | ||
67530 | 27609 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2695 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2000 12:00:00 AM | 3 | 3x3 | 6001941.56922 | 2115683.47507 | 37.7893726707572 | -122.437134613375 | (37.7893726707572, -122.437134613375) | 13 | 6 | 1 | 29490 | 27 | ||
149802 | 96017 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767661 | 6008768.28006 | 2115323.27409 | 37.7887693299764 | -122.413489408823 | (37.7887693299764, -122.413489408823) | 5 | 1 | 10 | 28858 | 21 |
166077 | 96016 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767661 | 6008769.14714 | 2115306.341 | 37.788722884507 | -122.41348521079 | (37.788722884507, -122.41348521079) | 5 | 1 | 10 | 28858 | 21 |
12100 | 96019 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
37840 | 96018 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
70980 | 96020 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
83415 | 107235 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008834.66692 | 2115296.44284 | 37.7886993852058 | -122.413257820814 | (37.7886993852058, -122.413257820814) | 5 | 1 | 10 | 28858 | 21 | |||
84156 | 125883 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008823.04151 | 2115295.32129 | 37.7886956530184 | -122.413297963833 | (37.7886956530184, -122.413297963833) | 5 | 1 | 10 | 28858 | 21 | |||
49184 | 125884 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008808.31826 | 2115292.90351 | 37.7886881877568 | -122.413348733254 | (37.7886881877568, -122.413348733254) | 5 | 1 | 10 | 28858 | 21 | |||
37894 | 45238 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 871 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2001 12:00:00 AM | Permit Number 44088 | 6008421.36689101 | 2115188.65226849 | 37.7883802062735 | -122.414680152021 | (37.7883802062735, -122.414680152021) | 5 | 1 | 10 | 28858 | 21 | |||
46632 | 21528 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1300 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2007 12:00:00 AM | 3 | 4X4 | 6006219.82958 | 2114935.40618 | 37.7875609181413 | -122.422279128893 | (37.7875609181413, -122.422279128893) | 13 | 9 | 1 | 28858 | 41 | ||
136875 | 84731 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 72 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2007 12:00:00 AM | Permit No. 49232 | 6013473 | 2114579 | 37.7869887683946 | -122.397159425184 | (37.7869887683946, -122.397159425184) | 6 | 2 | 9 | 28855 | 6 | |||
98519 | 48359 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1400X Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | 7 | 3x3 | Permit Number 45770 | 6005451 | 2114476 | 37.7862561057092 | -122.424906431455 | (37.7862561057092, -122.424906431455) | 13 | 9 | 11 | 28858 | 13 | |
61548 | 34932 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2770 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/1997 12:00:00 AM | 5 | Permit Number 38524 | 6000272.2691 | 2114453.3621 | 37.7859000712136 | -122.442821815392 | (37.7859000712136, -122.442821815392) | 13 | 6 | 1 | 29490 | 27 | ||
30336 | 125888 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 575 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008045.66737 | 2113749.49498 | 37.7844075146451 | -122.415878065725 | (37.7844075146451, -122.415878065725) | 7 | 10 | 9 | 28858 | 36 | |||
96910 | 114307 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 595 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008020 | 2113749 | 37.7844047125189 | -122.415966831143 | (37.7844047125189, -122.415966831143) | 7 | 10 | 9 | 28858 | 36 | ||||
176800 | 48441 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | 5 | Permit Number 45814 | 6000736.2676 | 2113774.3561 | 37.784062137114 | -122.441167778959 | (37.784062137114, -122.441167778959) | 15 | 6 | 11 | 29490 | 13 | ||
6670 | 48442 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
54152 | 48439 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
134728 | 48438 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
155439 | 48437 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
174074 | 48440 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
86810 | 139384 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1492 Broderick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000711.3822 | 2113738.0773 | 37.7839611073263 | -122.441251269333 | (37.7839611073263, -122.441251269333) | 15 | 6 | 11 | 29490 | 13 | |||
164089 | 139383 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6000714.3804 | 2113723.086 | 37.7839201158586 | -122.441239820711 | (37.7839201158586, -122.441239820711) | 15 | 6 | 11 | 29490 | 13 | |||
155733 | 139382 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1480 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000715.5797 | 2113708.6945 | 37.7838806688155 | -122.441234638662 | (37.7838806688155, -122.441234638662) | 15 | 6 | 11 | 29490 | 13 | |||
189901 | 41633 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100 Jordan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42113 | 5996241.92564567 | 2113793.75965037 | 37.7838583861175 | -122.456717884501 | (37.7838583861175, -122.456717884501) | 11 | 6 | 1 | 54 | 31 | |||
132598 | 139381 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1470 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000719.1776 | 2113696.7015 | 37.7838479440673 | -122.441221330523 | (37.7838479440673, -122.441221330523) | 15 | 6 | 11 | 29490 | 13 | |||
112690 | 139380 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1460 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000719.7772 | 2113684.7085 | 37.7838150485268 | -122.441218395368 | (37.7838150485268, -122.441218395368) | 15 | 6 | 11 | 29490 | 13 | |||
84293 | 140862 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100 Jordan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5996243.3642 | 2113769.3144 | 37.7837913485727 | -122.456711139169 | (37.7837913485727, -122.456711139169) | 11 | 6 | 1 | 54 | 31 | |||
23509 | 44343 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 233 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2001 12:00:00 AM | Permit Number 43727 | 5991164.04904901 | 2113857.0036857 | 37.7837391697575 | -122.474289891692 | (37.7837391697575, -122.474289891692) | 11 | 6 | 2 | 54 | 26 | |||
175317 | 39767 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 476 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2000 12:00:00 AM | 3 | 2x2 | Permit Number 42916 | 6008173.90648 | 2113469.9166 | 37.7836470686025 | -122.415414601899 | (37.7836470686025, -122.415414601899) | 7 | 10 | 9 | 28858 | 36 |
116464 | 125885 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 476 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008153.2935 | 2113467.57124 | 37.7836394702246 | -122.415485749065 | (37.7836394702246, -122.415485749065) | 7 | 10 | 9 | 28858 | 36 | |||
95201 | 24238 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 200X Willow St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1999 12:00:00 AM | 6 | 4X4 | 6006547.3507 | 2113418.3192 | 37.7834138390239 | -122.421038210119 | (37.7834138390239, -122.421038210119) | 7 | 9 | 11 | 28858 | 41 | ||
56273 | 43665 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 241 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 3 | Permit Number 43308 | 5992118.30424 | 2113674.27096 | 37.7832926725519 | -122.47097524296 | (37.7832926725519, -122.47097524296) | 11 | 6 | 2 | 54 | 11 | |
74489 | 24256 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 203 Willow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2014 12:00:00 AM | 3 | 2x3 | 6006439.8092 | 2113362.67149 | 37.7832549812742 | -122.421406308981 | (37.7832549812742, -122.421406308981) | 7 | 9 | 11 | 28858 | 41 | ||
165247 | 125886 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 260 Willow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006255.84548 | 2113363.12878 | 37.7832458630397 | -122.422042783457 | (37.7832458630397, -122.422042783457) | 7 | 9 | 11 | 28858 | 41 | |||
44831 | 125887 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 277 Willow St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006289.37196 | 2113344.72886 | 37.7831972322057 | -122.421925487583 | (37.7831972322057, -122.421925487583) | 7 | 9 | 11 | 28858 | 41 | |||
155717 | 125880 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2 Emerson St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 5998726.98974 | 2113474.62388 | 37.783124495049 | -122.448097535281 | (37.783124495049, -122.448097535281) | 15 | 6 | 1 | 54 | 31 | |||
81150 | 24248 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 265X Willow St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/1990 12:00:00 AM | 3 | 4x4 | 6006141.132777 | 2113311.4044124 | 37.783097370149 | -122.422435967678 | (37.783097370149, -122.422435967678) | 7 | 9 | 11 | 28858 | 41 | ||
191335 | 125879 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2 Emerson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 5998729.92991 | 2113444.41319 | 37.7830417124478 | -122.448085187582 | (37.7830417124478, -122.448085187582) | 15 | 6 | 1 | 54 | 31 | |||
164108 | 45767 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99 Blake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997811.6954 | 2113198.143 | 37.7823129863308 | -122.451244120994 | (37.7823129863308, -122.451244120994) | 15 | 6 | 1 | 54 | 31 |
127603 | 45765 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99 Blake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997815.0796 | 2113173.4382 | 37.7822453472 | -122.451230630986 | (37.7822453472, -122.451230630986) | 15 | 6 | 1 | 54 | 31 | |
98407 | 56330 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2526 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/1973 12:00:00 AM | 8 | Permit Number 12466 | 5987579.5629 | 2113304.96132 | 37.7820151066388 | -122.486650154768 | (37.7820151066388, -122.486650154768) | 11 | 6 | 2 | 55 | 26 | ||
14860 | 144376 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 390 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5986872.03276 | 2113312.07102 | 37.7819933565565 | -122.489098375585 | (37.7819933565565, -122.489098375585) | 11 | 6 | 2 | 55 | 26 | |||
96666 | 22595 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810X Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1992 12:00:00 AM | 6 | 4x4 | 6006111.72158 | 2112834.13473 | 37.7817852453704 | -122.422503794276 | (37.7817852453704, -122.422503794276) | 7 | 9 | 11 | 28852 | 41 | ||
30698 | 125889 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006091.49195 | 2112832.09387 | 37.781778500422 | -122.422573634365 | (37.781778500422, -122.422573634365) | 7 | 9 | 11 | 28852 | 41 | |||
105952 | 143860 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3215 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5985515.03599 | 2113176.32631 | 37.781541342893 | -122.493782888366 | (37.781541342893, -122.493782888366) | 11 | 6 | 2 | 55 | 26 | ||
37203 | 143861 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3201 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5985565.10939 | 2113174.24077 | 37.7815385460111 | -122.493609507183 | (37.7815385460111, -122.493609507183) | 11 | 6 | 2 | 55 | 26 | ||
100735 | 143858 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3239 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5985412.69263 | 2113173.41466 | 37.781527360227 | -122.494136727521 | (37.781527360227, -122.494136727521) | 11 | 6 | 2 | 55 | 26 | ||
168476 | 143859 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3227 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5985458.68749 | 2113171.92516 | 37.7815259617825 | -122.493977499883 | (37.7815259617825, -122.493977499883) | 11 | 6 | 2 | 55 | 26 | ||
16342 | 71996 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 340 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989363.9833 | 2113075.99146 | 37.7814902817874 | -122.48046018125 | (37.7814902817874, -122.48046018125) | 11 | 6 | 2 | 55 | 26 | |||
51972 | 254108 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3249 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x4 | 5985350 | 2113144 | 37.781442927388 | -122.494351441891 | (37.781442927388, -122.494351441891) | 11 | 6 | 2 | 55 | 26 | ||
138187 | 254107 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3249 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x4 | 5985350 | 2113144 | 37.781442927388 | -122.494351441891 | (37.781442927388, -122.494351441891) | 11 | 6 | 2 | 55 | 26 | ||
118441 | 71992 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3449 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/17/2018 12:00:00 AM | 3 | 5984787.84427 | 2113149.41844 | 37.7814248905972 | -122.496296599357 | (37.7814248905972, -122.496296599357) | 11 | 6 | 2 | 55 | 26 | ||
164292 | 254354 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3449 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/17/2018 12:00:00 AM | 3 | 5984787.84427 | 2113149.41844 | 37.7814248905972 | -122.496296599357 | (37.7814248905972, -122.496296599357) | 11 | 6 | 2 | 55 | 26 | ||
29254 | 71993 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3449 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/17/2018 12:00:00 AM | 3 | 5984766.04316 | 2113148.2827 | 37.7814204950816 | -122.496371935666 | (37.7814204950816, -122.496371935666) | 11 | 6 | 2 | 55 | 26 | ||
42353 | 118039 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3501 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 5ft | 5984617.86672 | 2113142.5664 | 37.7813961183692 | -122.496884124491 | (37.7813961183692, -122.496884124491) | 11 | 6 | 2 | 55 | 26 | ||
171568 | 61172 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 346 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 11 | Permit Number 27084 | 5989366.0565 | 2113024.18126 | 37.7813481459653 | -122.480449215491 | (37.7813481459653, -122.480449215491) | 11 | 6 | 2 | 55 | 26 | |
8978 | 71997 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 362 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5989369.28583 | 2112922.15861 | 37.7810682079879 | -122.48043057365 | (37.7810682079879, -122.48043057365) | 11 | 6 | 2 | 55 | 26 | |||
187673 | 65113 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 363 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 10 | Permit Number 27082 | 5989323.43538 | 2112903.08855 | 37.7810131823211 | -122.480587794991 | (37.7810131823211, -122.480587794991) | 11 | 6 | 2 | 55 | 26 | |
159203 | 69446 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 443 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | 10 | Permit Number 33556 | 5985911.81468 | 2112907.20872 | 37.7808256288006 | -122.492390419974 | (37.7808256288006, -122.492390419974) | 11 | 6 | 2 | 55 | 26 | |
79794 | 63193 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 435 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 12 | Permit Number 23733 | 5984052.79771 | 2112895.3666 | 37.7806842528122 | -122.498820690126 | (37.7806842528122, -122.498820690126) | 11 | 6 | 2 | 55 | 26 | |
132502 | 12325 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1015 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1997 12:00:00 AM | 6 | 4X4 | 6004759.9403 | 2112401.4167 | 37.7805207570776 | -122.427149495677 | (37.7805207570776, -122.427149495677) | 7 | 9 | 11 | 29490 | 41 | ||
160804 | 35218 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 896 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | 5 | Permit Number 40401 | 6011658.1335 | 2112244.4696 | 37.7804774939022 | -122.403274202035 | (37.7804774939022, -122.403274202035) | 6 | 2 | 9 | 28853 | 34 | ||
120697 | 35219 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 896 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | 7 | Permit Number 38722 | 6011641.6488 | 2112229.3585 | 37.7804350816614 | -122.403330167353 | (37.7804350816614, -122.403330167353) | 6 | 2 | 9 | 28853 | 34 | ||
148169 | 116626 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 5732X GEARY BLVD | 7 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
81110 | 9507 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 935 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005077.1287 | 2112297.1038 | 37.7802522713917 | -122.426044762205 | (37.7802522713917, -122.426044762205) | 7 | 9 | 11 | 28852 | 41 | |||
40222 | 87642 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1002X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004813.344433 | 2112300.663017 | 37.7802471321724 | -122.426957567511 | (37.7802471321724, -122.426957567511) | 7 | 9 | 11 | 28852 | 41 | |||||
132320 | 87643 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1002X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004813.344433 | 2112300.663017 | 37.7802471321724 | -122.426957567511 | (37.7802471321724, -122.426957567511) | 7 | 9 | 11 | 28852 | 41 | |||||
25373 | 110420 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 419X 18TH AVE | 18 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 3x3 | 5990240 | 2112557 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | 11 | 6 | 2 | 55 | 26 | |||
130511 | 12318 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 999 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/1997 12:00:00 AM | 6 | 4X4 | 6004783.3056 | 2112237.6551 | 37.7800724294036 | -122.427056996678 | (37.7800724294036, -122.427056996678) | 7 | 9 | 11 | 29490 | 41 | ||
37405 | 258000 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
53307 | 257999 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
71072 | 257997 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
78214 | 258004 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
96280 | 258008 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
98600 | 257994 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
103570 | 257998 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
104810 | 258003 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
109734 | 258005 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
131748 | 258002 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
132780 | 258006 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
141087 | 258007 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
147329 | 257996 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 |
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) );