trees
3,709 rows where qSpecies_id = 9 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1005 | 39481 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
2927 | 35280 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
4304 | 17630 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 150 Phelps St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10M | |||||||||||||
6966 | 35281 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
10720 | 39483 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
13401 | 35284 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
14355 | 35285 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
15594 | 19769 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
16339 | 39482 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
17767 | 35283 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
17923 | 19768 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
18560 | 19875 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY33 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
136 | 11131 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2400X Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007074.9072505 | 2120528.613771 | 37.802966665104 | -122.419717737051 | (37.802966665104, -122.419717737051) | 5 | 1 | 1 | 28858 | 32 | |||
580 | 65382 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1709 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/1989 12:00:00 AM | 9 | Permit Number 28221 | 6000542.2902 | 2114603.4223 | 37.7863274878262 | -122.441898393886 | (37.7863274878262, -122.441898393886) | 13 | 6 | 1 | 29490 | 27 | |
593 | 1419 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 41 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5X5PL | 5995462.58605 | 2115703.10829 | 37.7890561644519 | -122.459552424818 | (37.7890561644519, -122.459552424818) | 11 | 6 | 1 | 54 | 11 | |||
975 | 4380 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2421X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007006.0129161 | 2120659.6131485 | 37.8033224749672 | -122.419965449311 | (37.8033224749672, -122.419965449311) | 5 | 1 | 1 | 28858 | 32 | |||
1196 | 41203 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 18 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1999 12:00:00 AM | 9 | Permit Number 41910 | 5993961.82877 | 2115413.43591 | 37.7881743948276 | -122.464723766289 | (37.7881743948276, -122.464723766289) | 11 | 6 | 1 | 54 | 11 | ||
1662 | 30844 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 238 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/1995 12:00:00 AM | 9 | Permit Number 34692 | 5999056.13874 | 2115758.23439 | 37.7894135017764 | -122.447123215185 | (37.7894135017764, -122.447123215185) | 13 | 6 | 1 | 29490 | 31 | |
1842 | 11178 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2741 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006856.2652 | 2121744.00393 | 37.8062914977061 | -122.420560679149 | (37.8062914977061, -122.420560679149) | 5 | 1 | 1 | 28858 | 32 | |||
2011 | 264734 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1364 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006427.83864 | 2119405.514 | 37.7998464469137 | -122.42187710854 | (37.7998464469137, -122.42187710854) | 13 | 9 | 1 | 28858 | 32 | |||||
2288 | 50724 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3110 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2004 12:00:00 AM | 2 | Permit Number 47275 | 6001439.94101 | 2119110.04202 | 37.798752603299 | -122.439115871123 | (37.798752603299, -122.439115871123) | 13 | 9 | 1 | 57 | 17 | |
2707 | 19008 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3080X Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000062.56676 | 2115470.42095 | 37.7886806928938 | -122.443620414474 | (37.7886806928938, -122.443620414474) | 13 | 6 | 1 | 29490 | 27 | |||
2873 | 73548 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1707 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000544.9075 | 2114594.6979 | 37.7863036820207 | -122.441888712315 | (37.7863036820207, -122.441888712315) | 13 | 6 | 1 | 29490 | 27 | |||
2976 | 138679 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1719 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6000526.15 | 2114747.8117 | 37.7867230240237 | -122.441964602207 | (37.7867230240237, -122.441964602207) | 13 | 6 | 1 | 29490 | 27 | |||
3058 | 11168 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2666 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6006944.2763295 | 2121452.6056321 | 37.8054963520093 | -122.420235406119 | (37.8054963520093, -122.420235406119) | 5 | 1 | 1 | 28858 | 32 | |||
3065 | 131818 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 245 Alhambra St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001145.96871 | 2120047.09018 | 37.8013087580395 | -122.440200340178 | (37.8013087580395, -122.440200340178) | 13 | 9 | 1 | 57 | 17 | |||
3655 | 131989 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2445 Hyde St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006994.979 | 2120718.72375 | 37.803484156018 | -122.420007829916 | (37.803484156018, -122.420007829916) | 5 | 1 | 1 | 28858 | 32 | |||
5468 | 19026 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3173 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 5999643.72529 | 2115362.65802 | 37.7883609073807 | -122.44506178917 | (37.7883609073807, -122.44506178917) | 13 | 6 | 1 | 29490 | 27 | |||
5805 | 131998 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2526 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007014.37433 | 2120962.81861 | 37.8041554711661 | -122.419958043454 | (37.8041554711661, -122.419958043454) | 5 | 1 | 1 | 28858 | 32 | |||
6161 | 103626 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2729 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770186 | 5999911.184 | 2118103.33782 | 37.79590135493 | -122.444333461525 | (37.79590135493, -122.444333461525) | 13 | 9 | 1 | 57 | 17 | |
7307 | 17780 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1791 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005376.6767315 | 2115458.3552628 | 37.7889492101001 | -122.425233498798 | (37.7889492101001, -122.425233498798) | 13 | 9 | 1 | 28858 | 41 | |||
7522 | 131891 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3211 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 5999369.54226 | 2115325.66446 | 37.7882436798582 | -122.446007752769 | (37.7882436798582, -122.446007752769) | 13 | 6 | 1 | 29490 | 31 | |||
7778 | 138593 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2816 PINE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000380.1632 | 2114818.3649 | 37.7869084247529 | -122.44247474757 | (37.7869084247529, -122.44247474757) | 13 | 6 | 1 | 29490 | 27 | |||
8377 | 42837 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1258 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2000 12:00:00 AM | 14 | Permit Number 42769 | 6005846.59276 | 2120362.48981 | 37.8024412617221 | -122.423956527271 | (37.8024412617221, -122.423956527271) | 5 | 9 | 1 | 28858 | 32 | ||
8449 | 131913 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2108 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6004558.4355 | 2116754.37575 | 37.7924614957554 | -122.428156903513 | (37.7924614957554, -122.428156903513) | 13 | 9 | 1 | 28858 | 27 | |||
9726 | 87886 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3750 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50857 | 6002562.15931 | 2121499.01412 | 37.8053758844436 | -122.4354036226 | (37.8053758844436, -122.4354036226) | 13 | 9 | 1 | 57 | 17 | |
10208 | 250096 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1701 Pine St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6005700.60971 | 2115508.13842 | 37.789104197049 | -122.42411627476 | (37.789104197049, -122.42411627476) | 13 | 9 | 1 | 28858 | 41 | |||
10431 | 48599 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1338(Revised) Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50644 | 6006556.20417 | 2119076.48456 | 37.7989502536048 | -122.42140953573 | (37.7989502536048, -122.42140953573) | 13 | 9 | 1 | 28858 | 32 | |
10555 | 18999 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3039 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6000252.38525 | 2115449.79519 | 37.7886348840283 | -122.442962190565 | (37.7886348840283, -122.442962190565) | 13 | 6 | 1 | 29490 | 27 | |||
10904 | 131990 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2445 Hyde St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2020 12:00:00 AM | 3 | Width 3ft | 6006996.42169 | 2120694.04403 | 37.8034164730582 | -122.420001084983 | (37.8034164730582, -122.420001084983) | 5 | 1 | 1 | 28858 | 32 | ||
12572 | 1414 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 15 Arguello Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 20 | 3X5 | 5995457.5707 | 2115860.24617 | 37.7894873341044 | -122.459581162818 | (37.7894873341044, -122.459581162818) | 11 | 6 | 1 | 54 | 11 | |||
12828 | 131988 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2445 Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2020 12:00:00 AM | 3 | Width 3ft | 6006993.00733 | 2120736.62098 | 37.8035331861796 | -122.420015923817 | (37.8035331861796, -122.420015923817) | 5 | 1 | 1 | 28858 | 32 | ||
13048 | 131805 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2474 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999492.72938 | 2119826.91207 | 37.8006099461438 | -122.445905412604 | (37.8006099461438, -122.445905412604) | 13 | 9 | 1 | 57 | 17 | |||
13090 | 131960 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1340 Lombard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005876.90863 | 2120024.68366 | 37.8015154438506 | -122.423827585198 | (37.8015154438506, -122.423827585198) | 5 | 9 | 1 | 28858 | 32 | |||
14364 | 107684 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 330 Seacliff Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.07251 | 2115557.06448 | 37.7881509278055 | -122.489650845774 | (37.7881509278055, -122.489650845774) | 11 | 6 | 1 | 55 | 33 | ||
15184 | 32343 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2885 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36904 | 5999249.30586492 | 2118007.60671846 | 37.7956007178544 | -122.446616785481 | (37.7956007178544, -122.446616785481) | 13 | 9 | 1 | 57 | 17 | |||
15215 | 131795 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3460 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5999250.62549 | 2120749.14861 | 37.8031283320577 | -122.446809584704 | (37.8031283320577, -122.446809584704) | 13 | 9 | 1 | 57 | 17 | |||
15587 | 259045 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 255 Seacliff Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 775322 | 5986944 | 2115700 | 37.7885541240961 | -122.489025008772 | (37.7885541240961, -122.489025008772) | 11 | 6 | 1 | 55 | 33 | |
15828 | 17912 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2328 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/1991 12:00:00 AM | 15 | 3X3 | 6002774 | 2115172 | 37.7880155732413 | -122.434217921172 | (37.7880155732413, -122.434217921172) | 13 | 9 | 1 | 29490 | 27 | ||
16856 | 11172 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2717 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6006856.95142 | 2121692.8865 | 37.8061511809927 | -122.420554673483 | (37.8061511809927, -122.420554673483) | 5 | 1 | 1 | 28858 | 32 | |||
16977 | 140823 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 620 EUCLID AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5996399.8843 | 2113855.1043 | 37.7840358904974 | -122.456175846275 | (37.7840358904974, -122.456175846275) | 11 | 6 | 1 | 54 | 31 | |||
17282 | 18916 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2621 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 6x5 | 6002236.03231 | 2115724.70658 | 37.7895026155894 | -122.4361187581 | (37.7895026155894, -122.4361187581) | 13 | 6 | 1 | 29490 | 27 | |||
18046 | 71265 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1707 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000547.9611 | 2114579.8664 | 37.7862631325586 | -122.441877082784 | (37.7862631325586, -122.441877082784) | 13 | 6 | 1 | 29490 | 27 | |||
18494 | 250097 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1701 Pine St | 3 | : | Tree | Private 2 | 4 | Width 3ft | 6005753.06256 | 2115514.84991 | 37.7891255865184 | -122.423935271799 | (37.7891255865184, -122.423935271799) | 13 | 9 | 1 | 28858 | 41 | |||
19868 | 58044 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3610 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/1977 12:00:00 AM | 4 | 3x3 | Permit Number 52572 | 5997549.51686 | 2115121.38224 | 37.7875786779699 | -122.452289957933 | (37.7875786779699, -122.452289957933) | 11 | 6 | 1 | 54 | 31 | |
19910 | 8737 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3250 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5997009.0435 | 2113012.7724 | 37.7817580176257 | -122.454007533534 | (37.7817580176257, -122.454007533534) | 11 | 6 | 1 | 54 | 31 | |||
20129 | 131915 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2040 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6004317.21326 | 2115889.70211 | 37.7900736698198 | -122.428929865418 | (37.7900736698198, -122.428929865418) | 13 | 9 | 1 | 28858 | 27 | |||
20204 | 132002 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2347 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007031.64315 | 2120451.58082 | 37.8027527149307 | -122.419861984153 | (37.8027527149307, -122.419861984153) | 5 | 1 | 1 | 28858 | 32 | |||
20277 | 131922 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1545 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005575.80497 | 2118541.65889 | 37.7974264333367 | -122.42476397727 | (37.7974264333367, -122.42476397727) | 13 | 9 | 1 | 57 | 17 | |||
21339 | 250471 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 330 Seacliff Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986750.2083 | 2115540.31584 | 37.7881043649685 | -122.489683741616 | (37.7881043649685, -122.489683741616) | 11 | 6 | 1 | 55 | 33 | |||
21458 | 19018 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3150 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | 01/19/2011 12:00:00 AM | 3 | 3X3 | Permit Number 767112 | 5999751.82821 | 2115426.62042 | 37.7885427008259 | -122.444692371063 | (37.7885427008259, -122.444692371063) | 13 | 6 | 1 | 29490 | 27 | |
21629 | 132003 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2319 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6007044.49031 | 2120339.60529 | 37.8024459822598 | -122.419809576178 | (37.8024459822598, -122.419809576178) | 5 | 1 | 1 | 28858 | 32 | |||
21749 | 120838 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 55 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 7ft | 5989873.67504 | 2114823.8325 | 37.7863189706432 | -122.478824785693 | (37.7863189706432, -122.478824785693) | 11 | 6 | 1 | 55 | 33 | |||
22301 | 17791 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1830 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005168.1437793 | 2115479.8612246 | 37.7889964771069 | -122.425956526841 | (37.7889964771069, -122.425956526841) | 13 | 9 | 1 | 28858 | 27 | |||
22392 | 4382 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2391X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007031.7831469 | 2120474.7837859 | 37.8028164322768 | -122.419863147129 | (37.8028164322768, -122.419863147129) | 5 | 1 | 1 | 28858 | 32 | |||
22485 | 138680 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1719 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000528.3311 | 2114726.873 | 37.7866656560633 | -122.441955552688 | (37.7866656560633, -122.441955552688) | 13 | 6 | 1 | 29490 | 27 | |||
23017 | 17880 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2204 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003377.8686741 | 2115231.1135652 | 37.788212139478 | -122.432132867359 | (37.788212139478, -122.432132867359) | 13 | 9 | 1 | 29490 | 27 | |||
23066 | 115227 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 22 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775148 | 5988276.3 | 2115892 | 37.7891589710102 | -122.484429598969 | (37.7891589710102, -122.484429598969) | 11 | 6 | 1 | 61 | 30 | |||
23547 | 250468 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 330 Seacliff Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986773.71453 | 2115563.25883 | 37.7881687321606 | -122.489604103052 | (37.7881687321606, -122.489604103052) | 11 | 6 | 1 | 55 | 33 | |||
23768 | 131865 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 555 Marina Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000313.87819 | 2121622.81545 | 37.8055878690403 | -122.443192967399 | (37.8055878690403, -122.443192967399) | 13 | 9 | 1 | 57 | 17 | |||
25216 | 41766 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1320-1360 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 4 | 3x3 | Permit Number 42186 | 6006043.0799 | 2120046.29254 | 37.8015841556561 | -122.423254093806 | (37.8015841556561, -122.423254093806) | 5 | 9 | 1 | 28858 | 32 | |
25388 | 250487 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 222 El Camino Del Mar | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5987893.38095 | 2115356.60419 | 37.7876666226671 | -122.485715124257 | (37.7876666226671, -122.485715124257) | 11 | 6 | 1 | 55 | 33 | |||
25908 | 132007 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2319 Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6007057.56905 | 2120239.89866 | 37.8021729498859 | -122.419757238308 | (37.8021729498859, -122.419757238308) | 5 | 1 | 1 | 28858 | 32 | |||
26288 | 124398 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3920 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5995972.08379 | 2115555.35439 | 37.7886797552779 | -122.457778943801 | (37.7886797552779, -122.457778943801) | 11 | 6 | 1 | 54 | 31 | |||
26318 | 11153 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2603 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6006916.69653 | 2121280.21725 | 37.8050214634311 | -122.420318606842 | (37.8050214634311, -122.420318606842) | 5 | 1 | 1 | 28858 | 32 | |||
26773 | 123009 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 34 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5993966.17504 | 2115303.87912 | 37.7878738324176 | -122.464700770315 | (37.7878738324176, -122.464700770315) | 11 | 6 | 1 | 54 | 11 | |||
27212 | 250888 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 188 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5986832.35186 | 2114485.18332 | 37.7852120706333 | -122.489321932679 | (37.7852120706333, -122.489321932679) | 11 | 6 | 1 | 55 | 33 | |||
27819 | 131863 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3640 Lyon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5998876.58216 | 2121318.22377 | 37.8046694831589 | -122.448144966435 | (37.8046694831589, -122.448144966435) | 13 | 9 | 1 | 57 | 17 | |||
28110 | 19037 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3235 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999309.28069 | 2115314.23141 | 37.7882088463949 | -122.446215424205 | (37.7882088463949, -122.446215424205) | 13 | 6 | 1 | 29490 | 31 | |||
28155 | 106768 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 226 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x9 | 6001629.46862 | 2120633.92047 | 37.8029475537601 | -122.438569291156 | (37.8029475537601, -122.438569291156) | 13 | 9 | 1 | 57 | 17 | ||||
28684 | 131822 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3515 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997963.12776 | 2115785.79139 | 37.7894266552706 | -122.450906879748 | (37.7894266552706, -122.450906879748) | 11 | 6 | 1 | 54 | 31 | |||
29787 | 131877 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3533 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6002622.38757 | 2120752.94987 | 37.80333080903 | -122.435141800264 | (37.80333080903, -122.435141800264) | 13 | 9 | 1 | 57 | 17 | |||
30111 | 17958 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2500 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1992 12:00:00 AM | 6 | 3x3 | 6001912.0842 | 2115029.0126 | 37.7875740088989 | -122.437189749529 | (37.7875740088989, -122.437189749529) | 13 | 6 | 1 | 29490 | 27 | ||
30775 | 131798 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3550 Baker St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5999217.12066 | 2121060.49219 | 37.8039812832582 | -122.446947946285 | (37.8039812832582, -122.446947946285) | 13 | 9 | 1 | 57 | 17 | |||
30787 | 132008 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2319 Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6007059.59383 | 2120223.92691 | 37.8021292095665 | -122.419749097642 | (37.8021292095665, -122.419749097642) | 5 | 1 | 1 | 28858 | 32 | |||
30866 | 17767 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1725 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2000 12:00:00 AM | 4 | 3x3 | 6005655.45235 | 2115499.57318 | 37.7890781293118 | -122.424271904233 | (37.7890781293118, -122.424271904233) | 13 | 9 | 1 | 28858 | 41 | ||
31045 | 58389 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1364 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2016 12:00:00 AM | 3 | Permit Number 776620 | 6006427.83864 | 2119405.514 | 37.7998464469137 | -122.42187710854 | (37.7998464469137, -122.42187710854) | 13 | 9 | 1 | 28858 | 32 | ||
31429 | 131784 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2672 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6000209.69016 | 2118190.51282 | 37.7961577408457 | -122.443306841341 | (37.7961577408457, -122.443306841341) | 13 | 9 | 1 | 57 | 17 | |||
31620 | 131917 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1870 Sacramento St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6005825.85678 | 2116265.47758 | 37.7911907321235 | -122.423736805829 | (37.7911907321235, -122.423736805829) | 13 | 9 | 1 | 28858 | 27 | |||
32179 | 87737 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 9 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.28256 | 37.8051028305372 | -122.4252793245 | (37.8051028305372, -122.4252793245) | 5 | 1 | 1 | 28858 | 32 | ||
32349 | 88001 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 801 Bay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50823 | 6006952 | 2121180 | 37.8047482816685 | -122.420189317926 | (37.8047482816685, -122.420189317926) | 5 | 1 | 1 | 28858 | 32 | ||
32484 | 13316 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3221X Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999405.93635 | 2115329.62799 | 37.7882566408208 | -122.445882120937 | (37.7882566408208, -122.445882120937) | 13 | 6 | 1 | 29490 | 31 | |||
32560 | 124649 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 19 Arguello Blvd | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 4ft | 5995460.13919 | 2115780.29786 | 37.7892679654039 | -122.459566483421 | (37.7892679654039, -122.459566483421) | 11 | 6 | 1 | 54 | 11 | |||
32861 | 11174 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2721 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006871.9159428 | 2121607.3582758 | 37.8059171856884 | -122.420496811264 | (37.8059171856884, -122.420496811264) | 5 | 1 | 1 | 28858 | 32 | |||
32906 | 18829 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1940 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4.5x4.5 | 6005473.09052 | 2116220.8866 | 37.791048376629 | -122.424954193796 | (37.791048376629, -122.424954193796) | 13 | 9 | 1 | 28858 | 27 | |||
32965 | 131910 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2435 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000745.64312 | 2116710.09379 | 37.7921234459845 | -122.441346062983 | (37.7921234459845, -122.441346062983) | 13 | 6 | 1 | 29490 | 27 | |||
33259 | 7944 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1715X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6005719.3289 | 2115506.1033 | 37.7890996659994 | -122.424051363883 | (37.7890996659994, -122.424051363883) | 13 | 9 | 1 | 28858 | 41 | |||
34303 | 137821 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2260 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003077.7361 | 2115191.2965 | 37.7880857910494 | -122.433168428468 | (37.7880857910494, -122.433168428468) | 13 | 9 | 1 | 29490 | 27 | |||
34582 | 131829 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3340 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5998854.41167 | 2115628.92476 | 37.7890469237318 | -122.447811852154 | (37.7890469237318, -122.447811852154) | 13 | 6 | 1 | 54 | 31 | |||
34740 | 12506 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 LAKE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5995351 | 2115102 | 37.7873992668989 | -122.459894934345 | (37.7873992668989, -122.459894934345) | 11 | 6 | 1 | 54 | 11 |
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) );