trees
953 rows where qSpecies_id = 60 sorted by Supervisor Districts
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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | ||
| 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 | |
| 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 | |||
| 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 |
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 |
| 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 | |
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 |
| 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 | |||
| 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 |
| 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 | |||
| 1130 | 54772 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1446 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1972 12:00:00 AM | 4x5 | Permit Number 10621 | 5994307.43834186 | 2105670.05162948 | 37.7614415732371 | -122.462820895269 | (37.7614415732371, -122.462820895269) | 1 | 5 | 11 | 56 | 12 | ||
| 1169 | 12272 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 700X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/1997 12:00:00 AM | 3 | 3X3 | 6004950.3992 | 2111308.9655 | 37.7775319231116 | -122.426412801229 | (37.7775319231116, -122.426412801229) | 7 | 9 | 11 | 28852 | 10 | ||
| 4319 | 71268 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1733 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5999451.8492 | 2110818.1122 | 37.775871807627 | -122.445398751236 | (37.775871807627, -122.445398751236) | 15 | 5 | 11 | 29492 | 16 | |||
| 5060 | 141961 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 861 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004842.0409 | 2111803.9569 | 37.7788849220533 | -122.426822909349 | (37.7788849220533, -122.426822909349) | 7 | 9 | 11 | 28852 | 41 | |||
| 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 | |||
| 8829 | 141965 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 803 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004856.9254 | 2111690.3911 | 37.7785739398403 | -122.426763328248 | (37.7785739398403, -122.426763328248) | 7 | 9 | 11 | 28852 | 41 | |||
| 22092 | 30745 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 486X Page St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004274.8073 | 2109806.6859 | 37.773368818647 | -122.42864278458 | (37.773368818647, -122.42864278458) | 7 | 9 | 11 | 28852 | 10 |
| 22182 | 246011 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 609 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1988 12:00:00 AM | 8 | Width 0ft | Permit Number 25501 | 5998952.4081 | 2108635.9977 | 37.7698517546883 | -122.446969376408 | (37.7698517546883, -122.446969376408) | 15 | 5 | 11 | 29492 | 9 | |
| 22879 | 248397 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 710 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5997610.5725 | 2108098.1732 | 37.7682982739336 | -122.451571931383 | (37.7682982739336, -122.451571931383) | 15 | 5 | 11 | 29492 | 9 | |||
| 24955 | 26493 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 519 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004978.6865 | 2110816.0585 | 37.7761801200302 | -122.426279843947 | (37.7761801200302, -122.426279843947) | 7 | 9 | 11 | 28852 | 10 | |||
| 25180 | 30744 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004178.56485 | 2109886.01831 | 37.7735811988523 | -122.428981357915 | (37.7735811988523, -122.428981357915) | 7 | 9 | 11 | 28852 | 10 |
| 25949 | 30741 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
| 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 | |||
| 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 | ||||
| 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 | |||||
| 43425 | 222591 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 310 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003760.57016 | 2108690.93214 | 37.7702761156764 | -122.430341981792 | (37.7702761156764, -122.430341981792) | 15 | 9 | 11 | 29492 | 10 | |||
| 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 | |||
| 45571 | 244276 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 480 Page St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004294.0037 | 2109808.1625 | 37.7733739594079 | -122.428576486808 | (37.7733739594079, -122.428576486808) | 7 | 9 | 11 | 28852 | 10 | |||
| 51674 | 221343 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 24 Alma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998466.64161 | 2106282.9763 | 37.7633631889881 | -122.448480141942 | (37.7633631889881, -122.448480141942) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | ||||
| 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 | |||
| 57934 | 30739 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
| 61510 | 10401 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1360 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5999635.0074 | 2108810.0697 | 37.7703686867394 | -122.44462080278 | (37.7703686867394, -122.44462080278) | 15 | 5 | 11 | 29492 | 9 | |||
| 62252 | 31341 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 430 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772811 | 6005729.4209 | 2111051.1148 | 37.7768679337671 | -122.423699563703 | (37.7768679337671, -122.423699563703) | 7 | 9 | 11 | 28852 | 10 | |
| 69488 | 111230 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1113 SCOTT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001842 | 2112262 | 37.7799725127801 | -122.4372340286 | (37.7799725127801, -122.4372340286) | 15 | 5 | 11 | 29490 | 41 | ||||
| 70462 | 173881 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1245 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996703 | 2107106 | 37.7655220059747 | -122.454639431756 | (37.7655220059747, -122.454639431756) | 15 | 5 | 11 | 29492 | 12 | ||||
| 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 | ||||
| 71961 | 204617 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 621 Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993792.55608 | 2107303.5698 | 37.7658971178728 | -122.464720270343 | (37.7658971178728, -122.464720270343) | 11 | 8 | 11 | 56 | 12 | |||
| 72831 | 30743 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
| 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 | ||
| 74685 | 30746 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004256.1031 | 2109802.2559 | 37.7733555963905 | -122.428707169176 | (37.7733555963905, -122.428707169176) | 7 | 9 | 11 | 28852 | 10 |
| 77849 | 54369 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1444 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | 4x6 | Permit Number 10135 | 5994306.99010384 | 2105683.08083554 | 37.76147732224 | -122.462823390787 | (37.76147732224, -122.462823390787) | 1 | 5 | 11 | 56 | 12 | ||
| 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 | ||||
| 79938 | 26491 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 912X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/1998 12:00:00 AM | 6 | 4X4 | 6004848.1679 | 2112085.98552 | 37.7796596496687 | -122.426821804086 | (37.7796596496687, -122.426821804086) | 7 | 9 | 11 | 28852 | 41 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 94013 | 244035 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 516 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998007.9741 | 2108736.9943 | 37.7700750633327 | -122.450243417124 | (37.7700750633327, -122.450243417124) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | ||
| 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 | ||||
| 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 | ||
| 96967 | 10387 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1352 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5999669.18514 | 2108830.5589 | 37.7704268951205 | -122.444504055148 | (37.7704268951205, -122.444504055148) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |
| 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 | ||||
| 103464 | 244272 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 460 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004370.7894 | 2109821.4524 | 37.7734147953727 | -122.428311821621 | (37.7734147953727, -122.428311821621) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | ||||
| 103861 | 139823 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 900 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004831 | 2112025 | 37.7794912277556 | -122.426876850808 | (37.7794912277556, -122.426876850808) | 7 | 9 | 11 | 28852 | 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 | ||||
| 109888 | 204619 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1367 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5994238.00536 | 2106214.43805 | 37.762932317501 | -122.463100533768 | (37.762932317501, -122.463100533768) | 1 | 5 | 11 | 56 | 12 | |||
| 111470 | 142317 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 442 LYON ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 0ft | 6000199.2759 | 2110472.9787 | 37.7749667974297 | -122.442788429748 | (37.7749667974297, -122.442788429748) | 15 | 5 | 11 | 29492 | 16 | |||
| 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 | |||
| 117131 | 54368 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1440 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | 4x6 | Permit Number 10134 | 5994306.09362611 | 2105709.13929636 | 37.7615488203786 | -122.462828381839 | (37.7615488203786, -122.462828381839) | 1 | 5 | 11 | 56 | 12 | ||
| 117911 | 100285 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1426 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 10129 | 5994323.3 | 2105790 | 37.7617718339078 | -122.462774738749 | (37.7617718339078, -122.462774738749) | 1 | 5 | 11 | 56 | 12 | ||||
| 121977 | 41599 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 11 Haight St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42106 | 6006168.11250893 | 2109650.54781373 | 37.7730470683498 | -122.422082471983 | (37.7730470683498, -122.422082471983) | 7 | 2 | 11 | 28852 | 10 | |||
| 123566 | 222592 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 352 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003592.38415 | 2108668.42769 | 37.7702047958459 | -122.430922129977 | (37.7702047958459, -122.430922129977) | 15 | 9 | 11 | 29492 | 10 | |||
| 126745 | 244273 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 466 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004356.0229 | 2109819.4835 | 37.7734085536944 | -122.428362760697 | (37.7734085536944, -122.428362760697) | 7 | 9 | 11 | 28852 | 10 | |||
| 127141 | 244917 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1350 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999690.9856 | 2108819.5575 | 37.7703979319451 | -122.444427856782 | (37.7703979319451, -122.444427856782) | 15 | 5 | 11 | 29492 | 9 | |||
| 128001 | 54367 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1434 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 10133 | 5994304.74891037 | 2105748.22696325 | 37.7616560675176 | -122.462835868431 | (37.7616560675176, -122.462835868431) | 1 | 5 | 11 | 56 | 12 | |||
| 128212 | 204616 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 621 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993775.2241 | 2107303.26916 | 37.7658952931499 | -122.464780195752 | (37.7658952931499, -122.464780195752) | 11 | 8 | 11 | 56 | 12 | |||
| 128554 | 30747 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 496X Page St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004231.9845 | 2109799.7949 | 37.7733474740483 | -122.428790423308 | (37.7733474740483, -122.428790423308) | 7 | 9 | 11 | 28852 | 10 |
| 128985 | 38681 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1725 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1998 12:00:00 AM | 3x3 | Permit Number 40598 | 5999507.78485898 | 2110823.62249875 | 37.7758901304473 | -122.445205652379 | (37.7758901304473, -122.445205652379) | 15 | 5 | 11 | 29492 | 16 | |
| 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 | ||
| 131341 | 54365 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1426 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 10129 | 5994302.95595576 | 2105800.34386055 | 37.7617990637215 | -122.46284585059 | (37.7617990637215, -122.46284585059) | 1 | 5 | 11 | 56 | 12 | |||
| 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 | ||||
| 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 |
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) );