trees
8,659 rows where qSpecies_id = 11 sorted by TreeID 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1924 | 96221 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2015 09:36:00 AM | 3 | 3x3 | 6006663 | 2110979.9 | 37.7767250501872 | -122.420464968339 | (37.7767250501872, -122.420464968339) | 7 | 9 | 11 | 28852 | 10 | ||
156070 | 96220 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/03/2011 12:00:00 AM | 1 | 3x3 | 6006663 | 2110979.9 | 37.7767250501872 | -122.420464968339 | (37.7767250501872, -122.420464968339) | 7 | 9 | 11 | 28852 | 10 | ||
97837 | 96219 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2015 09:39:00 AM | 3 | 3x3 | 6006663 | 2110979.9 | 37.7767250501872 | -122.420464968339 | (37.7767250501872, -122.420464968339) | 7 | 9 | 11 | 28852 | 10 | ||
102438 | 9613 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1395 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2009 12:00:00 AM | 6 | 3X3 | 6002966.29895 | 2111980.33246 | 37.7792629716694 | -122.433324446066 | (37.7792629716694, -122.433324446066) | 15 | 9 | 11 | 29490 | 41 | ||
38679 | 96124 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 401 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2015 12:00:00 AM | 3x3 | Permit Number 775982 | 6008080 | 2096981 | 37.7383670222757 | -122.414572277483 | (37.7383670222757, -122.414572277483) | 2 | 7 | 7 | 28859 | 2 | |
175168 | 96030 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 753 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/2016 12:00:00 AM | 2 | 3x3 | Permit Number 774797 | 6007450.19055 | 2113968.20942 | 37.784974556074 | -122.417953724392 | (37.784974556074, -122.417953724392) | 7 | 9 | 9 | 28858 | 36 |
131965 | 96 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6002409.38596 | 2107682.72677 | 37.7674312030188 | -122.434943602286 | (37.7674312030188, -122.434943602286) | 15 | 5 | 5 | 28862 | 3 | |||
87578 | 95848 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 379 TEHAMA ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767571 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 |
136102 | 95846 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 35 Stanford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767570 | 6014922.67926 | 2112357.79195 | 37.7809704334876 | -122.391988435332 | (37.7809704334876, -122.391988435332) | 6 | 2 | 9 | 28856 | 6 |
81550 | 95801 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 924 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767545 | 6015548.9 | 2102556.9 | 37.7540940681023 | -122.389137470822 | (37.7540940681023, -122.389137470822) | 10 | 3 | 8 | 28856 | 29 | |
109802 | 958 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1532 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/1990 12:00:00 AM | 20 | 3x3 | 6001957.73964 | 2093255.08174 | 37.7277906483939 | -122.43547356646 | (37.7277906483939, -122.43547356646) | 9 | 7 | 6 | 28861 | 25 | ||
115818 | 9578 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1290X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/1990 12:00:00 AM | 6 | 3X3 | 6003420.82158 | 2112116.63137 | 37.7796629895862 | -122.431761799017 | (37.7796629895862, -122.431761799017) | 15 | 9 | 11 | 29490 | 41 | ||
30221 | 95757 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 260 Madrid St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/25/2017 04:33:00 PM | 3 | 3x3 | Permit Number 767495 | 6003435.4103 | 2092233.16774 | 37.7250685138993 | -122.430292354528 | (37.7250685138993, -122.430292354528) | 9 | 7 | 6 | 28861 | 5 |
44331 | 95756 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 260 Madrid St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/25/2017 04:16:00 PM | 3 | 3x3 | Permit Number 767495 | 6003442.24703 | 2092244.67659 | 37.7251005018853 | -122.430269541405 | (37.7251005018853, -122.430269541405) | 9 | 7 | 6 | 28861 | 5 |
50118 | 95752 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 260 Madrid St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/25/2017 03:47:00 PM | 3 | 3x3 | Permit Number 767495 | 6003490.3309 | 2092321.64943 | 37.7253145756058 | -122.430108809186 | (37.7253145756058, -122.430108809186) | 9 | 7 | 6 | 28861 | 5 |
183530 | 95751 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 260 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/25/2017 04:36:00 PM | 3 | 3x3 | Permit Number 767495 | 6003552.81378 | 2092420.08444 | 37.7255883948789 | -122.429899830124 | (37.7255883948789, -122.429899830124) | 9 | 7 | 6 | 28861 | 5 |
118847 | 9570 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1256 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2001 12:00:00 AM | 18 | 3x3 | 6003577.5855756 | 2112136.5847154 | 37.7797266614591 | -122.431220909335 | (37.7797266614591, -122.431220909335) | 15 | 9 | 11 | 29490 | 41 | ||
71230 | 9567 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 921X Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 4X4 | 6003850.41733 | 2111875.81235 | 37.7790261026874 | -122.430258455908 | (37.7790261026874, -122.430258455908) | 15 | 9 | 11 | 29490 | 41 | |||
50353 | 9566 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 921X Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4X4 | 6003850.41733 | 2111875.81235 | 37.7790261026874 | -122.430258455908 | (37.7790261026874, -122.430258455908) | 15 | 9 | 11 | 29490 | 41 | |||
186018 | 9565 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 921X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4X4 | 6003850.41733 | 2111875.81235 | 37.7790261026874 | -122.430258455908 | (37.7790261026874, -122.430258455908) | 15 | 9 | 11 | 29490 | 41 | |||
178586 | 9564 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 921X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 4X4 | 6003831.42584 | 2112082.64792 | 37.7795929461074 | -122.43033891609 | (37.7795929461074, -122.43033891609) | 15 | 9 | 11 | 29490 | 41 | |||
115296 | 95636 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 11X Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767402 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 |
167334 | 9563 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 921X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 4X4 | 6003826.44271 | 2112098.31102 | 37.7796356708267 | -122.430357272703 | (37.7796356708267, -122.430357272703) | 15 | 9 | 11 | 29490 | 41 | |||
179178 | 95585 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 550 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767375 | 6010712 | 2107435 | 37.7672189155552 | -122.406208392149 | (37.7672189155552, -122.406208392149) | 8 | 4 | 8 | 28853 | 19 | |
31246 | 95555 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1333@ Larkin Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6007144.77428 | 2115357.51496 | 37.7887720549458 | -122.419108949446 | (37.7887720549458, -122.419108949446) | 13 | 9 | 10 | 28858 | 21 | ||||
56509 | 95507 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | 3x3 | 5985983.58763 | 2112182.96811 | 37.7788412674233 | -122.492088785464 | (37.7788412674233, -122.492088785464) | 11 | 6 | 2 | 55 | 26 | |||
129627 | 95506 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3X3 | 5985984.41707 | 2112207.80318 | 37.7789095059085 | -122.4920877452 | (37.7789095059085, -122.4920877452) | 11 | 6 | 2 | 55 | 26 | |||
123553 | 95503 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5985983.49633 | 2112291.66361 | 37.7791397088392 | -122.492097106557 | (37.7791397088392, -122.492097106557) | 11 | 6 | 2 | 55 | 26 | |||
48931 | 95501 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X 32nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5985979.29593 | 2112362.71829 | 37.7793345591202 | -122.492116870392 | (37.7793345591202, -122.492116870392) | 11 | 6 | 2 | 55 | 26 | |||
110253 | 95500 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X 32nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5985980.30461 | 2112381.8602 | 37.7793871762895 | -122.492114790789 | (37.7793871762895, -122.492114790789) | 11 | 6 | 2 | 55 | 26 | |||
52553 | 955 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1520 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/1990 12:00:00 AM | 12 | 3X4 | 6001995.30869 | 2093307.83613 | 37.7279376336162 | -122.435347461737 | (37.7279376336162, -122.435347461737) | 9 | 7 | 6 | 28861 | 25 | ||
67777 | 95312 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 6025 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013653.15717 | 2091450.97752 | 37.7234942425453 | -122.394915680158 | (37.7234942425453, -122.394915680158) | 10 | 3 | 8 | 58 | 1 | |||
53233 | 95311 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6013946.59114 | 2092277.54811 | 37.725780151342 | -122.393959158182 | (37.725780151342, -122.393959158182) | 10 | 3 | 8 | 58 | 1 | |||
167476 | 95305 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5548 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6014020 | 2112266 | 37.7806682371679 | -122.395104840735 | (37.7806682371679, -122.395104840735) | 6 | 2 | 9 | 28856 | 34 | |||
12063 | 95300 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | |||
151632 | 95299 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | |||
167062 | 95294 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4702 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2014 12:00:00 AM | 3 | 3x3 | 6014972.44587 | 2095814.62234 | 37.7355492045967 | -122.390659885752 | (37.7355492045967, -122.390659885752) | 10 | 3 | 8 | 58 | 1 | ||
36927 | 95272 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2245 Jones St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/08/2011 12:00:00 AM | 3 | 3x3 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | |
63375 | 95192 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 723 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769100 | 6009186.21224 | 2115482.95364 | 37.7892312289946 | -122.412054706857 | (37.7892312289946, -122.412054706857) | 5 | 1 | 10 | 28858 | 21 | |
153504 | 951 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1490 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6002107.46195 | 2093463.77312 | 37.7283721698404 | -122.434970893103 | (37.7283721698404, -122.434970893103) | 9 | 7 | 6 | 28861 | 25 | |||
105575 | 95093 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99X 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | Permit Number 771124 | 6008785.98711 | 2111225.82851 | 37.777519721304 | -122.413138294803 | (37.777519721304, -122.413138294803) | 8 | 2 | 9 | 28853 | 34 | |
138911 | 95092 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2010 12:00:00 AM | 3 | 3x3 | Permit Number 771124 | 6008785.98711 | 2111225.82851 | 37.777519721304 | -122.413138294803 | (37.777519721304, -122.413138294803) | 8 | 2 | 9 | 28853 | 34 | |
122142 | 95091 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2013 12:00:00 AM | 3 | 3x3 | Permit Number 771124 | 6008785.98711 | 2111225.82851 | 37.777519721304 | -122.413138294803 | (37.777519721304, -122.413138294803) | 8 | 2 | 9 | 28853 | 34 | |
14389 | 95083 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 730@ Waller Stanyan Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2010 12:00:00 AM | 3x3 | Permit Number 54023 | ||||||||||||
190165 | 95 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6002436.73331 | 2107684.77563 | 37.7674383813948 | -122.434849158187 | (37.7674383813948, -122.434849158187) | 15 | 5 | 5 | 28862 | 3 | |||
60995 | 94978 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 480 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2010 12:00:00 AM | 3x3 | Permit Number 54004 | 6008554 | 2113863 | 37.7847477369808 | -122.414127437729 | (37.7847477369808, -122.414127437729) | 7 | 10 | 9 | 28852 | 36 | ||
35214 | 94933 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 33@ Hester Lois Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53980 | 6012381 | 2087786 | 37.7133601315811 | -122.399056203003 | (37.7133601315811, -122.399056203003) | 10 | 3 | 8 | 309 | 1 | |||
40940 | 94923 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1065 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7.5x4 | 6007671 | 2103488.9 | 37.7562132685643 | -122.416447250312 | (37.7562132685643, -122.416447250312) | 2 | 4 | 7 | 28859 | 19 | ||||
123913 | 94905 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3701 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 5997052.16883 | 2115336.27243 | 37.7881402047485 | -122.454026199863 | (37.7881402047485, -122.454026199863) | 11 | 6 | 1 | 54 | 31 | ||||
45305 | 94902 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3701 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2010 12:00:00 AM | Permit Number 53961 | 5997125 | 2115346 | 37.78817108981 | -122.453774920639 | (37.78817108981, -122.453774920639) | 11 | 6 | 1 | 54 | 31 | |||
84178 | 94812 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3695X 03rd St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015935.10482 | 2098700.92618 | 37.7435277680723 | -122.387532876065 | (37.7435277680723, -122.387532876065) | 10 | 3 | 8 | 58 | 1 | |||
167134 | 94811 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3695X 03rd St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015935.10482 | 2098700.92618 | 37.7435277680723 | -122.387532876065 | (37.7435277680723, -122.387532876065) | 10 | 3 | 8 | 58 | 1 | |||
37684 | 94810 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3695X 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015935.10482 | 2098700.92618 | 37.7435277680723 | -122.387532876065 | (37.7435277680723, -122.387532876065) | 10 | 3 | 8 | 58 | 1 | |||
111809 | 94809 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3695X 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015935.10482 | 2098700.92618 | 37.7435277680723 | -122.387532876065 | (37.7435277680723, -122.387532876065) | 10 | 3 | 8 | 58 | 1 | |||
140080 | 94808 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3695X 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015935.10482 | 2098700.92618 | 37.7435277680723 | -122.387532876065 | (37.7435277680723, -122.387532876065) | 10 | 3 | 8 | 58 | 1 | |||
51277 | 94806 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3695X 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015935.10482 | 2098700.92618 | 37.7435277680723 | -122.387532876065 | (37.7435277680723, -122.387532876065) | 10 | 3 | 8 | 58 | 1 | |||
137577 | 94804 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3695X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015935.10482 | 2098700.92618 | 37.7435277680723 | -122.387532876065 | (37.7435277680723, -122.387532876065) | 10 | 3 | 8 | 58 | 1 | |||
146081 | 94803 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3695X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015935.10482 | 2098700.92618 | 37.7435277680723 | -122.387532876065 | (37.7435277680723, -122.387532876065) | 10 | 3 | 8 | 58 | 1 | |||
58469 | 94802 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3695X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015935.10482 | 2098700.92618 | 37.7435277680723 | -122.387532876065 | (37.7435277680723, -122.387532876065) | 10 | 3 | 8 | 58 | 1 | |||
141773 | 94692 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2635 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53829 | 6002619.58306 | 2117298.56999 | 37.7938458230845 | -122.434904317176 | (37.7938458230845, -122.434904317176) | 13 | 9 | 1 | 29490 | 27 | |
116570 | 94691 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2635 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53829 | 6002615.03526 | 2117321.47902 | 37.7939084671525 | -122.434921692099 | (37.7939084671525, -122.434921692099) | 13 | 9 | 1 | 29490 | 27 | |
31106 | 94644 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2049X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6012373.4025 | 2088201.60487 | 37.7145008763988 | -122.399111617204 | (37.7145008763988, -122.399111617204) | 10 | 3 | 8 | 309 | 1 | |||
38319 | 94643 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2049X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6012360.99131 | 2088176.10992 | 37.7144301806933 | -122.399152727014 | (37.7144301806933, -122.399152727014) | 10 | 3 | 8 | 309 | 1 | ||||
117547 | 94642 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2090 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2010 12:00:00 AM | 3 | 6012050.15275 | 2087939.7205 | 37.7137637749513 | -122.400210523116 | (37.7137637749513, -122.400210523116) | 10 | 7 | 8 | 309 | 39 | |||
105461 | 94640 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2084 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6012083.4831 | 2087979.90881 | 37.7138759824729 | -122.400098141134 | (37.7138759824729, -122.400098141134) | 10 | 7 | 8 | 309 | 39 | |||
133031 | 94639 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2000X Bay Shore Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/11/2016 12:04:00 PM | 3 | 3x3 | 6012318.2 | 2088514.6 | 37.71535722204 | -122.399324379639 | (37.71535722204, -122.399324379639) | 10 | 7 | 8 | 309 | 39 | ||
170249 | 94628 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 200X Arkansas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2014 12:00:00 AM | 3 | 9x9 | Permit Number 771061 | 6012865.81371 | 2105997.2123 | 37.7633913098769 | -122.398657706913 | (37.7633913098769, -122.398657706913) | 14 | 3 | 8 | 28856 | 29 | |
130947 | 94627 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 200X Arkansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2010 12:00:00 AM | 1 | 9x9 | Permit Number 53779 | 6012864.90886 | 2106027.48058 | 37.7634743694561 | -122.398662960746 | (37.7634743694561, -122.398662960746) | 14 | 3 | 8 | 28856 | 29 | |
177034 | 94596 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2520 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010715.9 | 2086627.1 | 37.710085095387 | -122.404729862288 | (37.710085095387, -122.404729862288) | 9 | 7 | 8 | 309 | 39 | ||||
71907 | 94595 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2450 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010809.3 | 2086846.3 | 37.7106921945144 | -122.404422470916 | (37.7106921945144, -122.404422470916) | 9 | 7 | 8 | 309 | 39 | ||||
18100 | 94592 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2428 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2016 10:36:00 AM | 3 | 3x3 | 6010911.88561 | 2086922.4145 | 37.7109069219836 | -122.404073263263 | (37.7109069219836, -122.404073263263) | 9 | 7 | 8 | 309 | 39 | ||
95500 | 94591 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2260 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6011152.33862 | 2087310.95436 | 37.7119872065292 | -122.403269511287 | (37.7119872065292, -122.403269511287) | 9 | 7 | 8 | 309 | 39 | |||
73612 | 94590 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2260 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6011161.44702 | 2087323.58946 | 37.7120224086757 | -122.403238918143 | (37.7120224086757, -122.403238918143) | 9 | 7 | 8 | 309 | 39 | |||
39299 | 94589 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2260 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6011173.46811 | 2087340.97309 | 37.7120708119918 | -122.403198591637 | (37.7120708119918, -122.403198591637) | 9 | 7 | 8 | 309 | 39 | |||
32164 | 94520 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 66 Mint St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53709 | 6010457.75748 | 2112950.83929 | 37.7823499053575 | -122.407476702589 | (37.7823499053575, -122.407476702589) | 14 | 2 | 9 | 28853 | 34 | |
120255 | 94519 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 66 Mint St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53709 | 6010439.05219 | 2112971.38471 | 37.7824052712293 | -122.407542863929 | (37.7824052712293, -122.407542863929) | 14 | 2 | 9 | 28853 | 34 | |
57568 | 94509 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1460 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2010 12:00:00 AM | 3x3 | Permit Number 53694 | 6006521 | 2115394.6 | 37.788838734384 | -122.42126975784 | (37.788838734384, -122.42126975784) | 13 | 9 | 10 | 28858 | 21 | ||
149030 | 94508 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1460 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2012 12:00:00 AM | 3x3 | Permit Number 768540 | 6006521 | 2115394.6 | 37.788838734384 | -122.42126975784 | (37.788838734384, -122.42126975784) | 13 | 9 | 10 | 28858 | 21 | ||
55384 | 94507 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1452 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2010 12:00:00 AM | 3x3 | Permit Number 53694 | 6006542 | 2115327 | 37.788654305406 | -122.421192298538 | (37.788654305406, -122.421192298538) | 13 | 9 | 10 | 28858 | 21 | ||
58495 | 9432 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 727 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005971.0045 | 2112414.18829 | 37.7806242358464 | -122.422960753834 | (37.7806242358464, -122.422960753834) | 7 | 9 | 11 | 28852 | 41 | |||
166494 | 94319 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/25/2011 12:00:00 AM | 1 | 3x3 | 6006663 | 2110979.9 | 37.7767250501872 | -122.420464968339 | (37.7767250501872, -122.420464968339) | 7 | 9 | 11 | 28852 | 10 | ||
30884 | 94312 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5800 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013721.0222 | 2091953.33052 | 37.7248773762602 | -122.39471624425 | (37.7248773762602, -122.39471624425) | 10 | 3 | 8 | 58 | 1 | ||
51458 | 9426 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 701X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/01/1994 12:00:00 AM | 3 | 3X3 | 6006163.88269 | 2112441.42785 | 37.7807099106779 | -122.422295430885 | (37.7807099106779, -122.422295430885) | 7 | 9 | 11 | 28852 | 41 | ||
49396 | 9425 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 701X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767203 | 6006146.15187 | 2112440.43547 | 37.7807061856781 | -122.422356699899 | (37.7807061856781, -122.422356699899) | 7 | 9 | 11 | 28852 | 41 | |
122879 | 94241 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 38 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2010 12:00:00 AM | 4x4 | Permit Number 53566 | 6015842.4 | 2114626.7 | 37.7872513611082 | -122.388965095302 | (37.7872513611082, -122.388965095302) | 6 | 2 | 9 | 28855 | 6 | ||
139386 | 9423 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 701X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767203 | 6006097.44245 | 2112434.65303 | 37.7806875607269 | -122.422524798491 | (37.7806875607269, -122.422524798491) | 7 | 9 | 11 | 28852 | 41 | |
17539 | 9421 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 701X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767203 | 6006076.0707 | 2112433.28351 | 37.7806825946662 | -122.422598636412 | (37.7806825946662, -122.422598636412) | 7 | 9 | 11 | 28852 | 41 | |
56086 | 94113 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 233 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3x3 | Permit Number 53481 | 6006358.2 | 2110974.8 | 37.7766938654669 | -122.421519001363 | (37.7766938654669, -122.421519001363) | 7 | 9 | 11 | 28852 | 10 | ||
159962 | 94112 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 233 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3x3 | Permit Number 53481 | 6006358.2 | 2110974.8 | 37.7766938654669 | -122.421519001363 | (37.7766938654669, -122.421519001363) | 7 | 9 | 11 | 28852 | 10 | ||
94549 | 94111 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 233 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3x3 | Permit Number 53481 | 6006358.2 | 2110974.8 | 37.7766938654669 | -122.421519001363 | (37.7766938654669, -122.421519001363) | 7 | 9 | 11 | 28852 | 10 | ||
20923 | 9411 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 601X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1999 12:00:00 AM | 6 | 3X3 | 6006553.11457 | 2112551.33182 | 37.7810336281325 | -122.420956693216 | (37.7810336281325, -122.420956693216) | 7 | 9 | 11 | 28852 | 41 | ||
175333 | 94069 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2010 12:00:00 AM | 3x3 | Permit Number 53461. Tree 3 on 18th St. | 6015474 | 2105663 | 37.7626186026962 | -122.389613415677 | (37.7626186026962, -122.389613415677) | 10 | 3 | 8 | 28856 | 29 | ||
26618 | 94068 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2010 12:00:00 AM | 3x3 | Permit Number 53461. Tree 2 on 18th St. | 6015474 | 2105663 | 37.7626186026962 | -122.389613415677 | (37.7626186026962, -122.389613415677) | 10 | 3 | 8 | 28856 | 29 | ||
176734 | 94015 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1188 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53434 | 6008952.53402 | 2111406.54727 | 37.7780252805739 | -122.412574929614 | (37.7780252805739, -122.412574929614) | 8 | 2 | 9 | 28853 | 34 | |
94719 | 94014 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1188 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53434 | 6008970.85175 | 2111428.87862 | 37.7780876251877 | -122.412513140773 | (37.7780876251877, -122.412513140773) | 8 | 2 | 9 | 28853 | 34 | |
115209 | 94013 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1188 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53434 | 6008987.06913 | 2111441.41388 | 37.7781229541565 | -122.412457925105 | (37.7781229541565, -122.412457925105) | 8 | 2 | 9 | 28853 | 34 | |
177670 | 94 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6002488.78224 | 2107687.88267 | 37.7674498675536 | -122.434669350436 | (37.7674498675536, -122.434669350436) | 15 | 5 | 5 | 28862 | 3 | |||
74739 | 93886 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 2x3 | 6015698 | 2105385 | 37.7618676924716 | -122.388819264883 | (37.7618676924716, -122.388819264883) | 10 | 3 | 8 | 28856 | 29 | |||
88694 | 93884 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 638 19th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2010 12:00:00 AM | Permit Number 53372 | 6015650.9 | 2105380.7 | 37.7618532749442 | -122.388981866359 | (37.7618532749442, -122.388981866359) | 10 | 3 | 8 | 28856 | 29 | |||
86263 | 93883 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 638 19th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2010 12:00:00 AM | Permit Number 53372 | 6015650.9 | 2105380.7 | 37.7618532749442 | -122.388981866359 | (37.7618532749442, -122.388981866359) | 10 | 3 | 8 | 28856 | 29 |
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) );