trees
1,650 rows where qSpecies_id = 64 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
137 | 189330 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 23 | Median : Yard | Tree | DPW 1 | 15 | 6016163.75351 | 2096735.77367 | 37.7381445215441 | -122.386605256348 | (37.7381445215441, -122.386605256348) | 10 | 3 | 8 | 58 | 1 | ||||
150 | 247856 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 80 Bradford St | 5 | Side Yard : Yard | Tree | Private 2 | 32 | 6009566.84713 | 2098148.32022 | 37.7416556510973 | -122.409513828008 | (37.7416556510973, -122.409513828008) | 10 | 7 | 7 | 28859 | 2 | ||||
683 | 38304 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2000 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
1193 | 63195 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 492 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 7 | Permit Number 23736 | 5984412.04288 | 2112531.45624 | 37.7797061246547 | -122.497551031954 | (37.7797061246547, -122.497551031954) | 11 | 6 | 2 | 55 | 26 | |
1443 | 68991 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1882 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 2 | Permit Number 32984 | 5981356.0199 | 2102264.6652 | 37.7513368825607 | -122.507361024926 | (37.7513368825607, -122.507361024926) | 1 | 8 | 3 | 56 | 35 | |
2085 | 261253 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 245 Euclid Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | 5998181.06314 | 2113969.03195 | 37.7844507871641 | -122.450021856673 | (37.7844507871641, -122.450021856673) | 15 | 6 | 1 | 54 | 31 | |||
2492 | 205476 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Judson Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5999461.7393 | 2093534.48294 | 37.7284157437829 | -122.444122326784 | (37.7284157437829, -122.444122326784) | 9 | 7 | 4 | 63 | 40 | ||||
3002 | 43637 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 464 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2000 12:00:00 AM | Permit Number 43287 | 6006770.36235207 | 2101076.15554315 | 37.7495377351989 | -122.419390811234 | (37.7495377351989, -122.419390811234) | 2 | 4 | 7 | 28859 | 19 | ||
3234 | 41216 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1920 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/10/2019 12:00:00 AM | 3 | Permit Number 41924 | 5999991.94061 | 2121282.68763 | 37.8046356075044 | -122.444282616557 | (37.8046356075044, -122.444282616557) | 13 | 9 | 1 | 57 | 17 | |
3410 | 47847 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
3550 | 80000 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 8250 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5981404.80446 | 2112378.67743 | 37.7791099097712 | -122.507942852748 | (37.7791099097712, -122.507942852748) | 11 | 6 | 2 | 55 | 26 | |||
3918 | 71637 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3735 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5983967.42692 | 2111030.60647 | 37.7755591545959 | -122.498978209698 | (37.7755591545959, -122.498978209698) | 11 | 6 | 2 | 55 | 26 | |||
3945 | 70009 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1815 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6005608.75345 | 2092244.69483 | 37.725223029103 | -122.422780149308 | (37.725223029103, -122.422780149308) | 9 | 7 | 7 | 309 | 5 | |||
3946 | 52915 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3017th ST Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2006 12:00:00 AM | Permit Number 48903 | 6000815.25066305 | 2106175.88788155 | 37.7632031545323 | -122.440349407902 | (37.7632031545323, -122.440349407902) | 15 | 5 | 5 | 28862 | 3 | |||
4272 | 47849 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
4501 | 81295 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2274 45th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5982376.5473 | 2099668.9758 | 37.7442699020827 | -122.503639778557 | (37.7442699020827, -122.503639778557) | 1 | 8 | 3 | 29491 | 35 | |||
4511 | 245571 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4220 Cesar Chavez St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6002399.35344 | 2100348.21593 | 37.7472918291588 | -122.43445383688 | (37.7472918291588, -122.43445383688) | 2 | 4 | 5 | 63 | 22 | ||||
5334 | 83255 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 790 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2020 12:00:00 AM | 3 | 5983253.61867 | 2110435.38712 | 37.7738829587872 | -122.501403365431 | (37.7738829587872, -122.501403365431) | 11 | 6 | 2 | 55 | 26 | ||
5738 | 78347 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3301 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5985324.51094 | 2111082.60279 | 37.7757814311217 | -122.49428762949 | (37.7757814311217, -122.49428762949) | 11 | 6 | 2 | 55 | 26 | |||
6124 | 72278 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 716 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5983237.15085 | 2110912.93675 | 37.7751932045665 | -122.501495663732 | (37.7751932045665, -122.501495663732) | 11 | 6 | 2 | 55 | 26 | |||
7917 | 253285 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 8245 Geary Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 08/15/2017 12:00:00 AM | 3 | 5981372 | 2112274 | 37.7788205636315 | -122.508048563649 | (37.7788205636315, -122.508048563649) | 11 | 6 | 2 | 55 | 26 | |||
8100 | 60138 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3643 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/1982 12:00:00 AM | 4 | Permit Number 19668 | 5984225.13965 | 2111041.08493 | 37.7756030388028 | -122.498087506758 | (37.7756030388028, -122.498087506758) | 11 | 6 | 2 | 55 | 26 | |
8141 | 54006 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3300 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/05/1972 12:00:00 AM | 2 | Permit Number 9725 | 5985332.63941 | 2111140.64831 | 37.7759412831996 | -122.494263790905 | (37.7759412831996, -122.494263790905) | 11 | 6 | 2 | 55 | 26 | |
8187 | 37494 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1050 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39963 | 5991661.12122197 | 2105245.54821547 | 37.7601232248942 | -122.471942379719 | (37.7601232248942, -122.471942379719) | 1 | 8 | 4 | 56 | 12 | ||
8350 | 47846 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
8355 | 115419 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4219 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | Permit Number 772533 | 5981156.8 | 2104128.1 | 37.7564416084773 | -122.508188234142 | (37.7564416084773, -122.508188234142) | 1 | 8 | 3 | 56 | 35 | ||
9188 | 250134 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2550x Lyon St | 2 | Median : Yard | Tree | DPW 1 | 15 | 5999224.86929 | 2117537.18532 | 37.7943076699218 | -122.446667476532 | (37.7943076699218, -122.446667476532) | 13 | 9 | 1 | 57 | 27 | ||||
9317 | 69488 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 425 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | 20 | Permit Number 33610 | 6002125.08495 | 2093879.83517 | 37.7295155822594 | -122.434939712705 | (37.7295155822594, -122.434939712705) | 9 | 7 | 6 | 28861 | 25 | |
9818 | 47845 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
10665 | 70444 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3933 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5982611.2212 | 2104882.7837 | 37.758599355062 | -122.503214291779 | (37.758599355062, -122.503214291779) | 1 | 8 | 3 | 56 | 35 | |||
11155 | 71173 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2275 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5987604.645 | 2099825.288 | 37.7450050904406 | -122.485573834432 | (37.7450050904406, -122.485573834432) | 1 | 8 | 3 | 29491 | 35 | |||
11234 | 205417 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198 Mangels Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6000139.85205 | 2095251.72944 | 37.7331695655238 | -122.441901267552 | (37.7331695655238, -122.441901267552) | 9 | 7 | 5 | 63 | 40 | ||||
12456 | 205316 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 112 Marston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5998697.99683 | 2093223.72686 | 37.7275188804882 | -122.44674026046 | (37.7275188804882, -122.44674026046) | 9 | 7 | 4 | 28861 | 40 | ||||
12509 | 260552 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1822 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/27/2019 12:00:00 AM | 3 | 5983200.28736 | 2102724.03033 | 37.752706632515 | -122.501017410169 | (37.752706632515, -122.501017410169) | 1 | 8 | 3 | 56 | 35 | ||
13094 | 73612 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3634 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5984240.51587 | 2111098.24499 | 37.7757608853724 | -122.498038539599 | (37.7757608853724, -122.498038539599) | 11 | 6 | 2 | 55 | 26 | |||
13735 | 189282 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1310 Indiana St | 17 | : Yard | Tree | Private 2 | 2 | 6015006.25242 | 2102364.64044 | 37.753536067647 | -122.39100065687 | (37.753536067647, -122.39100065687) | 10 | 3 | 8 | 28856 | 29 | ||||
13776 | 79417 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 195 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6003642.56153 | 2094609.00455 | 37.7316037612939 | -122.429745633281 | (37.7316037612939, -122.429745633281) | 9 | 7 | 5 | 28861 | 25 | |||
13800 | 189286 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1301 Minnesota St | 70 | Front Yard : Yard | Tree | Private 2 | 3 | 6015368.15632 | 2102301.56591 | 37.7533829535663 | -122.389744698757 | (37.7533829535663, -122.389744698757) | 10 | 3 | 8 | 28856 | 29 | ||||
13857 | 260533 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1514 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | 5982198.3547 | 2104783.64712 | 37.7583028764812 | -122.504634801553 | (37.7583028764812, -122.504634801553) | 1 | 8 | 3 | 56 | 35 | ||
13865 | 69043 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1411 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 3 | Permit Number 33050 | 5983994.9059 | 2105527.4427 | 37.7604506461086 | -122.498476575537 | (37.7604506461086, -122.498476575537) | 1 | 8 | 3 | 56 | 35 | |
13910 | 62589 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3608 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 5 | Permit Number 22895 | 5984370.96748 | 2111102.16317 | 37.7757792910517 | -122.497587570945 | (37.7757792910517, -122.497587570945) | 11 | 6 | 2 | 55 | 26 | |
13936 | 189326 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 19 | Median : Yard | Tree | DPW 1 | 16 | 6016187.80706 | 2096717.46995 | 37.7380955948279 | -122.386520814503 | (37.7380955948279, -122.386520814503) | 10 | 3 | 8 | 58 | 1 | ||||
14951 | 124274 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 8 03rd Ave | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 5994910.91331 | 2114969.48118 | 37.7870100866839 | -122.46140792196 | (37.7870100866839, -122.46140792196) | 11 | 6 | 1 | 54 | 11 | ||||
15067 | 57250 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 115 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1975 12:00:00 AM | 12 | Permit Number 14539 | 6004961.23317 | 2092548.97797 | 37.7260219679128 | -122.425040204062 | (37.7260219679128, -122.425040204062) | 9 | 7 | 6 | 28861 | 5 | ||
15628 | 47848 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
16372 | 96327 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 296 Randall St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 767829 | 6003708 | 2097940 | 37.7407536226533 | -122.429756895294 | (37.7407536226533, -122.429756895294) | 2 | 7 | 5 | 63 | 7 | ||||
16797 | 47844 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
17008 | 29712 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1594X Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 6 | 6005909.34325 | 2099821.50359 | 37.7460442149832 | -122.422279116311 | (37.7460442149832, -122.422279116311) | 2 | 7 | 5 | 28859 | 22 | |||
19049 | 249699 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2400 Baker St | 31 | Front Yard : Yard | Tree | Private 2 | 13 | 5999692.34538 | 2117233.07075 | 37.7934993439788 | -122.445028087992 | (37.7934993439788, -122.445028087992) | 13 | 9 | 1 | 57 | 27 | ||||
19348 | 72159 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 141 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6000647.86105 | 2092393.26967 | 37.7253498290121 | -122.439940063787 | (37.7253498290121, -122.439940063787) | 9 | 7 | 6 | 28861 | 25 | |||
19369 | 62036 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1985 12:00:00 AM | 8 | Permit Number 22111 | 6004501.59533 | 2092915.26272 | 37.7270017298275 | -122.426655215587 | (37.7270017298275, -122.426655215587) | 9 | 7 | 6 | 28861 | 5 | |
20448 | 245794 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 30th St | 6 | Front Yard : Yard | Tree | Private 2 | 2 | 6002837.91517 | 2098354.25557 | 37.7418417639992 | -122.432794903371 | (37.7418417639992, -122.432794903371) | 2 | 7 | 5 | 63 | 7 | ||||
20550 | 205485 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 66 Marston Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5998899.62113 | 2093233.2174 | 37.7275564550591 | -122.446043928906 | (37.7275564550591, -122.446043928906) | 9 | 7 | 4 | 28861 | 40 | ||||
20608 | 205456 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 265 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | 6000331.96286 | 2094928.67856 | 37.7322934882457 | -122.441213920209 | (37.7322934882457, -122.441213920209) | 9 | 7 | 4 | 63 | 40 | ||||
20914 | 37196 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1651 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 3 | Permit Number 39763 | 5986529.3031 | 2104010.0255 | 37.7564325334524 | -122.489599795635 | (37.7564325334524, -122.489599795635) | 1 | 8 | 3 | 56 | 35 | |
22362 | 104523 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 51X BONVIEW ST | 1 | Front Yard : Yard | Tree | DPW 1 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | |||||
24296 | 33072 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1360 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | 7 | Permit Number 37332 | 6011469.86115 | 2119995.38405 | 37.8017491407824 | -122.404471277147 | (37.8017491407824, -122.404471277147) | 3 | 1 | 10 | 308 | 23 | ||
24636 | 48634 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1436 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45929 | 5990866.95707843 | 2105617.12188587 | 37.761097481488 | -122.474716107382 | (37.761097481488, -122.474716107382) | 1 | 8 | 4 | 56 | 12 | ||
24823 | 38314 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2000 Folsom St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
25592 | 68394 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 252 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/1993 12:00:00 AM | 4 | Permit Number 32222 | 6001581.94485 | 2093980.34457 | 37.7297607041954 | -122.436824590994 | (37.7297607041954, -122.436824590994) | 9 | 7 | 6 | 28861 | 25 | |
26297 | 60916 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 451 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1983 12:00:00 AM | 2 | Permit Number 49669 | 6001149.5729 | 2110298.5161 | 37.774541896461 | -122.43948864709 | (37.774541896461, -122.43948864709) | 15 | 5 | 11 | 29492 | 10 | ||
27710 | 39820 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2101 46th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/1999 12:00:00 AM | Permit Number 41148 | 5981978.01419846 | 2100783.80216684 | 37.7473074654157 | -122.505100399713 | (37.7473074654157, -122.505100399713) | 1 | 8 | 3 | 29491 | 35 | |||
30031 | 205447 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 321 Melrose Ave | 2 | : Yard | Tree | Private 2 | 2 | 5997960.43745 | 2095528.68593 | 37.7338055912481 | -122.4494560053 | (37.7338055912481, -122.4494560053) | 9 | 7 | 4 | 59 | 40 | ||||
30520 | 118591 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 101 Point Lobos Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5982483.31512 | 2112527.9777 | 37.7795833316153 | -122.504222970503 | (37.7795833316153, -122.504222970503) | 11 | 6 | 2 | 55 | 26 | ||||
31661 | 34649 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1735 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 40399 | 5987784.82467276 | 2103483.81569075 | 37.7550609240819 | -122.485219205847 | (37.7550609240819, -122.485219205847) | 1 | 8 | 3 | 56 | 35 | ||
32003 | 59294 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 357 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1980 12:00:00 AM | Permit Number 18631 | 5998269.35755712 | 2107529.98911826 | 37.7667758890994 | -122.449252327047 | (37.7667758890994, -122.449252327047) | 15 | 5 | 11 | 29492 | 9 | |||
32663 | 111520 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 800x BOSWORTH ST | 15 | Front Yard : Yard | Tree | DPW 1 | 7 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
33188 | 39188 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1189 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40841 | 6007685.90483064 | 2102746.1551156 | 37.7541746987817 | -122.416343098068 | (37.7541746987817, -122.416343098068) | 2 | 4 | 7 | 28859 | 19 | ||
35483 | 175955 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 73 Mansfield St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6005301.14037 | 2091779.76908 | 37.7239290836463 | -122.423810494468 | (37.7239290836463, -122.423810494468) | 9 | 7 | 6 | 309 | 5 | ||||
35773 | 205424 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 60 Melrose Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5999723.88526 | 2095534.65896 | 37.7339227117545 | -122.443359687323 | (37.7339227117545, -122.443359687323) | 9 | 7 | 4 | 63 | 40 | ||||
36282 | 38313 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2000 Folsom St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
36312 | 175957 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 63 La Grande Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6005285.01468 | 2091850.3565 | 37.7241219909335 | -122.423871255379 | (37.7241219909335, -122.423871255379) | 9 | 7 | 6 | 309 | 5 | ||||
36699 | 52596 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1739 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2006 12:00:00 AM | 2 | Permit Number 48690 | 5984069.4859 | 2103330.5247 | 37.7544228964765 | -122.498056398348 | (37.7544228964765, -122.498056398348) | 1 | 8 | 3 | 56 | 35 | ||
37258 | 205471 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Judson Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5999482.0353 | 2093535.39464 | 37.7284194049318 | -122.444052228249 | (37.7284194049318, -122.444052228249) | 9 | 7 | 4 | 63 | 40 | ||||
37481 | 39818 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2101 46th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/1999 12:00:00 AM | Permit Number 41148 | 5981978.01419846 | 2100783.80216684 | 37.7473074654157 | -122.505100399713 | (37.7473074654157, -122.505100399713) | 1 | 8 | 3 | 29491 | 35 | |||
38070 | 58144 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3614 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1978 12:00:00 AM | 3 | Permit Number 17128 | 5984347.59904 | 2111100.65093 | 37.7757737690712 | -122.497668295354 | (37.7757737690712, -122.497668295354) | 11 | 6 | 2 | 55 | 26 | ||
38273 | 111768 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 4966 17th St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5997580.2349427 | 2105651.04183436 | 37.7615773358373 | -122.45150033551 | (37.7615773358373, -122.45150033551) | 15 | 5 | 11 | 29492 | 9 | |||||
38452 | 189333 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 26 | Median : Yard | Tree | DPW 1 | 18 | 6016146.37557 | 2096749.3676 | 37.7381808856511 | -122.386666288817 | (37.7381808856511, -122.386666288817) | 10 | 3 | 8 | 58 | 1 | ||||
39210 | 54955 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1559 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2012 12:00:00 AM | 2 | Permit Number 769310 | 5982476.3168 | 2104511.3762 | 37.7575716444054 | -122.503653339691 | (37.7575716444054, -122.503653339691) | 1 | 8 | 3 | 56 | 35 | ||
39702 | 39841 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3151 Ortega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
40396 | 205472 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Judson Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 5999475.13727 | 2093536.59194 | 37.7284222989294 | -122.444076160988 | (37.7284222989294, -122.444076160988) | 9 | 7 | 4 | 63 | 40 | ||||
40683 | 205484 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 66 Marston Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998899.69714 | 2093230.40528 | 37.7275487379747 | -122.446043463958 | (37.7275487379747, -122.446043463958) | 9 | 7 | 4 | 28861 | 40 | ||||
40739 | 189335 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 29 | Median : Yard | Tree | DPW 1 | 15 | 6016137.08007 | 2096756.05642 | 37.7381987371688 | -122.386698894633 | (37.7381987371688, -122.386698894633) | 10 | 3 | 8 | 58 | 1 | ||||
41150 | 126123 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2836 Larkin St | 6 | Side Yard : Yard | Tree | Private 2 | 8 | 6006504.36606 | 2120972.74597 | 37.8041539827815 | -122.42172367341 | (37.8041539827815, -122.42172367341) | 5 | 9 | 1 | 28858 | 32 | ||||
42410 | 175876 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 670 Brunswick St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | 5998776.13579 | 2086731.33993 | 37.7096967402836 | -122.446003364979 | (37.7096967402836, -122.446003364979) | 9 | 7 | 6 | 28861 | 5 | ||||
42741 | 85021 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 299 Maywood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994525 | 2094707 | 37.7313523209144 | -122.461273710807 | (37.7313523209144, -122.461273710807) | 9 | 8 | 4 | 59 | 40 | |||||
42780 | 84884 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2895 HARRISON St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2007 12:00:00 AM | Permit No. 49261 | 6009003 | 2101605 | 37.7511153190475 | -122.411707614344 | (37.7511153190475, -122.411707614344) | 2 | 4 | 7 | 28859 | 19 | |||
43030 | 175875 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 670 Brunswick St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | 5998788.01102 | 2086736.62559 | 37.7097119316264 | -122.445962702139 | (37.7097119316264, -122.445962702139) | 9 | 7 | 6 | 28861 | 5 | ||||
43673 | 50397 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 126 Springfield Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | 3 | Permit Number 47048 | 5986815.96523 | 2095005.27155 | 37.7317246157805 | -122.487946825187 | (37.7317246157805, -122.487946825187) | 1 | 8 | 4 | 64 | 35 | |
43857 | 43115 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 200 Appleton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/13/2003 12:00:00 AM | Permit Number 42938 | 6005863.014 | 2096788.574 | 37.7377138611244 | -122.422223875233 | (37.7377138611244, -122.422223875233) | 2 | 7 | 7 | 28859 | 2 | ||
44109 | 35004 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3512 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2013 12:00:00 AM | 3 | Permit Number 768133 | 5984687.18249 | 2111113.68157 | 37.7758294476267 | -122.496494570085 | (37.7758294476267, -122.496494570085) | 11 | 6 | 2 | 55 | 26 | ||
44248 | 205475 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Judson Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 5999461.68909 | 2093522.86386 | 37.7283838376284 | -122.444121665807 | (37.7283838376284, -122.444121665807) | 9 | 7 | 4 | 63 | 40 | ||||
44940 | 49418 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 413@ 19th ST Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | 5 | Permit Number 46364 | 6014094.43855 | 2105154.43805 | 37.7611456110148 | -122.394349248338 | (37.7611456110148, -122.394349248338) | 10 | 3 | 8 | 28856 | 29 | ||
45288 | 205291 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 146 Stillings Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999811.4073 | 2095793.29434 | 37.7346378544461 | -122.44307566613 | (37.7346378544461, -122.44307566613) | 9 | 7 | 4 | 63 | 40 | ||||
45857 | 54528 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4650 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1972 12:00:00 AM | 21 | Permit Number 10323 | 5981096.26906 | 2110986.58772 | 37.7752694592632 | -122.508906792671 | (37.7752694592632, -122.508906792671) | 11 | 6 | 2 | 55 | 26 | ||
46089 | 44437 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 518 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 5 | Permit Number 43770 | 6002524.70573 | 2087459.34052 | 37.711909015872 | -122.433099632359 | (37.711909015872, -122.433099632359) | 9 | 7 | 6 | 28861 | 5 | |
46234 | 201493 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 410 Hawes St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6018736.96879 | 2094929.02833 | 37.7333256725358 | -122.377582915835 | (37.7333256725358, -122.377582915835) | 10 | 3 | 8 | 58 | 1 | ||||
46489 | 43221 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 47 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 12 | Permit Number 43010 | 6008377.13505 | 2094049.0426 | 37.7303331919052 | -122.413337641019 | (37.7303331919052, -122.413337641019) | 9 | 3 | 7 | 309 | 28 | |
47345 | 64887 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2516 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1989 12:00:00 AM | 5 | Permit Number 25913 | 5989259.2592 | 2098145.5523 | 37.7404892410979 | -122.479729655172 | (37.7404892410979, -122.479729655172) | 1 | 8 | 3 | 29491 | 35 | |
47870 | 189323 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 301x Cashmere St | 1 | Median : Yard | Tree | DPW 1 | 6 | 6016365.09613 | 2096197.70243 | 37.7366782309168 | -122.385871612795 | (37.7366782309168, -122.385871612795) | 10 | 3 | 8 | 58 | 1 |
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) );