trees
1,650 rows where qSpecies_id = 64
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12932 | 183321 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3927 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3 | Width 0ft | 5983491.8186 | 2106952.5519 | 37.7643340772207 | -122.500321858891 | (37.7643340772207, -122.500321858891) | 1 | 8 | 3 | 56 | 35 | ||
12970 | 146947 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 5982234.0104 | 2111588.65058 | 37.7769895502595 | -122.505015778681 | (37.7769895502595, -122.505015778681) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
13198 | 182354 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3131 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5985126.4539 | 2104969.219 | 37.7589842113346 | -122.494521978175 | (37.7589842113346, -122.494521978175) | 1 | 8 | 3 | 56 | 35 | |||
13700 | 104171 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 2607 DIAMOND ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6002306 | 2096613 | 37.7370304975493 | -122.434509617625 | (37.7370304975493, -122.434509617625) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||||
14211 | 185744 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2155 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5987262.8522 | 2100597.3636 | 37.7471050836115 | -122.486812362638 | (37.7471050836115, -122.486812362638) | 1 | 8 | 3 | 29491 | 35 | |||
14346 | 261807 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2257 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2020 12:00:00 AM | 3 | 4x6 | 5986031 | 2099874 | 37.7450470274178 | -122.491018723977 | (37.7450470274178, -122.491018723977) | 1 | 8 | 3 | 29491 | 35 | ||
14509 | 175884 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 431 Ellington Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 5998446.27134 | 2087485.89752 | 37.7117497423219 | -122.447197699721 | (37.7117497423219, -122.447197699721) | 9 | 7 | 6 | 28861 | 25 | |||
14709 | 5008 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5300 Diamond Heights Blvd | 25 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.7435139095193 | -122.437744874344 | (37.7435139095193, -122.437744874344) | 2 | 7 | 5 | 63 | 7 | |||
14890 | 261368 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 48 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007159 | 2095436 | 37.7340730065148 | -122.41764717788 | (37.7340730065148, -122.41764717788) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
15027 | 189344 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017767.18086 | 2096543.26443 | 37.7377045660164 | -122.381047966792 | (37.7377045660164, -122.381047966792) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
15107 | 245765 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 205 Beacon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6003079.9408 | 2097633.46199 | 37.7398763550104 | -122.431906602506 | (37.7398763550104, -122.431906602506) | 2 | 7 | 5 | 63 | 7 | |||
15183 | 189306 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 499 Texas St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6013832.17688 | 2104822.60916 | 37.7602198992576 | -122.395233060671 | (37.7602198992576, -122.395233060671) | 10 | 3 | 8 | 28856 | 29 | |||
15574 | 257971 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2375 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x5 | 5982047.40699 | 2098940.49295 | 37.7422503328302 | -122.504723889349 | (37.7422503328302, -122.504723889349) | 1 | 8 | 3 | 29491 | 35 | |||
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 | |||||||||||||
15718 | 119163 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 879 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5981371.77833 | 2109760.61565 | 37.7719195366042 | -122.507862758964 | (37.7719195366042, -122.507862758964) | 11 | 6 | 2 | 55 | 26 | |||
15929 | 20047 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 STAIRWAY52 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
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 | ||||
16659 | 245737 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 69 Levant St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6000363.9166 | 2106407.40728 | 37.7638131413848 | -122.441927035821 | (37.7638131413848, -122.441927035821) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||||||||||||
17004 | 259318 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 Wisconsin St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6012713 | 2104246 | 37.7585743521834 | -122.399063317374 | (37.7585743521834, -122.399063317374) | 10 | 3 | 8 | 28856 | 29 | |||||
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 | |||
17636 | 182797 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1790 25th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5988420.4979 | 2103123.6607 | 37.7541090451648 | -122.482994496098 | (37.7541090451648, -122.482994496098) | 1 | 8 | 3 | 56 | 35 | |||
17817 | 205248 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1436 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2002 12:00:00 AM | 6 | Width 3ft | Permit Number 45929 | 5990867.58094 | 2105598.65136 | 37.7610468024976 | -122.474712601602 | (37.7610468024976, -122.474712601602) | 1 | 8 | 4 | 56 | 12 | |
18190 | 261630 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 15 Noe St | 1 | Sidewalk: Curb side : Pot | Landscaping | Private 2 | 3x3 | 6002878 | 2108185 | 37.7688369185992 | -122.433358627279 | (37.7688369185992, -122.433358627279) | 15 | 5 | 5 | 28862 | 3 | ||||
18407 | 205380 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 82 Ventura Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994352.36671 | 2101824.80509 | 37.7508861010346 | -122.462386599787 | (37.7508861010346, -122.462386599787) | 1 | 8 | 4 | 29491 | 40 | |||
18575 | 245781 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 6 | Back Yard : Yard | Tree | Private 2 | 17 | Width 8ft | 6003587.5616 | 2096850.22083 | 37.7377545179491 | -122.430095602638 | (37.7377545179491, -122.430095602638) | 2 | 7 | 5 | 63 | 7 | |||
18677 | 189308 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1500 22nd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6013530.98263 | 2103856.35073 | 37.7575500090417 | -122.396207035432 | (37.7575500090417, -122.396207035432) | 10 | 3 | 8 | 28856 | 29 | |||
18720 | 245646 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 491 Bartlett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006820.96537 | 2100970.13931 | 37.7492494886697 | -122.419208304739 | (37.7492494886697, -122.419208304739) | 2 | 4 | 7 | 28859 | 19 | |||
18838 | 73634 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3729 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x6 | Permit Number 771233 | 5983991.83207 | 2111030.74195 | 37.775560958096 | -122.498893797707 | (37.775560958096, -122.498893797707) | 11 | 6 | 2 | 55 | 26 | |
18927 | 245716 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 190 Storrie St | 22 | Front Yard : Yard | Tree | Private 2 | 14 | Width 3ft | 6000826.49409 | 2105355.82769 | 37.7609521110737 | -122.440251708571 | (37.7609521110737, -122.440251708571) | 15 | 4 | 5 | 28862 | 3 | |||
18951 | 182910 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2650 Sloat Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982525.098 | 2096516.7401 | 37.7356234605352 | -122.502892823995 | (37.7356234605352, -122.502892823995) | 1 | 8 | 3 | 29491 | 35 | |||
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 | |
19718 | 205275 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2095 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5991604.96401 | 2101197.16645 | 37.7490041788106 | -122.471841547451 | (37.7490041788106, -122.471841547451) | 1 | 8 | 4 | 29491 | 12 | |||
19801 | 189390 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 41 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017676.30083 | 2096675.94876 | 37.7380638739522 | -122.38137140977 | (37.7380638739522, -122.38137140977) | 10 | 3 | 8 | 58 | 1 | |||
19896 | 118533 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 7919 Geary Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5982413.97815 | 2112333.29099 | 37.7790447011013 | -122.504448405405 | (37.7790447011013, -122.504448405405) | 11 | 6 | 2 | 55 | 26 | |||
20085 | 30016 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750X San Jose Ave | 8 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005691.52892 | 2098774.02454 | 37.7431557868143 | -122.422957855325 | (37.7431557868143, -122.422957855325) | 2 | 7 | 7 | 28859 | 2 | ||
20241 | 247240 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 921 Buena Vista Ave West | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6000040.78347 | 2108630.81284 | 37.7698996387736 | -122.443204350999 | (37.7698996387736, -122.443204350999) | 15 | 5 | 11 | 29492 | 9 | |||
20442 | 183863 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2234 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5985467.7521 | 2099991.2893 | 37.7453361487514 | -122.492974945054 | (37.7453361487514, -122.492974945054) | 1 | 8 | 3 | 29491 | 35 | |||
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 | ||||
20604 | 11607 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4300 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3X3 | 5981158.1048 | 2105571.7891 | 37.7604056423858 | -122.508290879089 | (37.7604056423858, -122.508290879089) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||||
20664 | 121198 | Property Tree 8 | Cordyline australis :: Dracena Palm 64 | 2521 18th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 5990743 | 2098231 | 37.740809941753 | -122.47460574514 | (37.740809941753, -122.47460574514) | 1 | 8 | 4 | 29491 | 40 | |||
20691 | 182914 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2650 Sloat Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5982494.64 | 2096518.7706 | 37.7356272455922 | -122.502998277506 | (37.7356272455922, -122.502998277506) | 1 | 8 | 3 | 29491 | 35 | |||
20753 | 245593 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3942 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 4ft | 6002215.74848 | 2102973.16119 | 37.7544888813619 | -122.435276458457 | (37.7544888813619, -122.435276458457) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |
20932 | 205329 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1x Minerva St | 21 | Median : Cutout | Tree | DPW 1 | 16 | Width 0ft | 5996217.25377 | 2089002.70313 | 37.7157869221923 | -122.455011281241 | (37.7157869221923, -122.455011281241) | 9 | 8 | 6 | 28861 | 24 | |||
20997 | 245569 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 661 27th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 5ft | 6002237.36498 | 2100017.36446 | 37.7463741924229 | -122.434990322071 | (37.7463741924229, -122.434990322071) | 2 | 7 | 5 | 63 | 22 | |||
21115 | 245718 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2423 Market St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 6002179.10375 | 2105823.91705 | 37.7623142880908 | -122.435607119382 | (37.7623142880908, -122.435607119382) | 15 | 4 | 5 | 28862 | 3 | |||
21169 | 247802 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 464 30th St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6003596.41299 | 2098374.599 | 37.7419406120734 | -122.43017371776 | (37.7419406120734, -122.43017371776) | 2 | 7 | 5 | 63 | 22 | |||
21232 | 182202 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1590 33rd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985937.2465 | 2104433.4826 | 37.7575606466666 | -122.491678477889 | (37.7575606466666, -122.491678477889) | 1 | 8 | 3 | 56 | 35 | |||
21297 | 126095 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3630 Webster St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6002627.04146 | 2121100.74155 | 37.8042860176436 | -122.435150585742 | (37.8042860176436, -122.435150585742) | 13 | 9 | 1 | 57 | 17 | |||
21561 | 205277 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 800 Pacheco St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5991460.19521 | 2101837.33618 | 37.7507535409505 | -122.472388816384 | (37.7507535409505, -122.472388816384) | 1 | 8 | 4 | 29491 | 12 | |||
21968 | 117803 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3720 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5983978.89251 | 2111088.19184 | 37.7757179399329 | -122.498942803524 | (37.7757179399329, -122.498942803524) | 11 | 6 | 2 | 55 | 26 | |||
22286 | 245677 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4206 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | Width 3ft | 6001747.19308 | 2102367.94443 | 37.7528004815642 | -122.436853519485 | (37.7528004815642, -122.436853519485) | 2 | 4 | 5 | 28862 | 22 | |||
22325 | 205391 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1110 Teresita Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998274.92773 | 2095667.87912 | 37.7342057679854 | -122.448378743402 | (37.7342057679854, -122.448378743402) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||||
22498 | 92364 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1910 33rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2009 12:00:00 AM | 3x3 | Permit Number 52777 | 5986038.6 | 2102202.7 | 37.7514414512274 | -122.491163791724 | (37.7514414512274, -122.491163791724) | 1 | 8 | 3 | 29491 | 35 | |
22582 | 182407 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1542 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984998.5258 | 2104706.1132 | 37.7582543079017 | -122.494945007359 | (37.7582543079017, -122.494945007359) | 1 | 8 | 3 | 56 | 35 | |||
22602 | 205411 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Joost Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 6ft | 6001323.45002 | 2094964.81551 | 37.7324491402005 | -122.43778871637 | (37.7324491402005, -122.43778871637) | 9 | 7 | 5 | 63 | 40 | |||
22806 | 175944 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1764 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5997944.4131 | 2088561.35887 | 37.7146740246601 | -122.449009674469 | (37.7146740246601, -122.449009674469) | 9 | 7 | 6 | 28861 | 25 | |||
22863 | 245511 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4050 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6003542.64667 | 2100711.61579 | 37.748354472576 | -122.430526340145 | (37.748354472576, -122.430526340145) | 2 | 4 | 5 | 28862 | 22 | |||
22954 | 245688 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 420 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 3ft | 6002929.60866 | 2105769.94295 | 37.7622086870078 | -122.433007549864 | (37.7622086870078, -122.433007549864) | 15 | 4 | 5 | 28862 | 3 | |||
23277 | 189302 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1345 20th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013921.81731 | 2104751.14346 | 37.760028654829 | -122.394918029061 | (37.760028654829, -122.394918029061) | 10 | 3 | 8 | 28856 | 29 | |||
23326 | 245667 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 33 Valley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005668.95498 | 2099318.86171 | 37.7446505122149 | -122.423074627805 | (37.7446505122149, -122.423074627805) | 2 | 7 | 5 | 28859 | 22 | |||
23466 | 175898 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 9 Prague St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6004985.20772 | 2091051.63703 | 37.721911951944 | -122.424850846398 | (37.721911951944, -122.424850846398) | 9 | 7 | 6 | 28861 | 5 | |||
23604 | 175889 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 963 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001524.34401 | 2088591.42567 | 37.7149606745828 | -122.436638139935 | (37.7149606745828, -122.436638139935) | 9 | 7 | 6 | 28861 | 5 | |||
23629 | 118111 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3501 Balboa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5984683.93077 | 2111059.4403 | 37.7756803261768 | -122.496501814988 | (37.7756803261768, -122.496501814988) | 11 | 6 | 2 | 55 | 26 | |||
23712 | 247156 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3970 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002541.66359 | 2105921.45047 | 37.7626026772901 | -122.434360135613 | (37.7626026772901, -122.434360135613) | 15 | 4 | 5 | 28862 | 3 | |||
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 | ||
24473 | 182913 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2650 Sloat Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5982496.6705 | 2096518.7706 | 37.735627364936 | -122.502991257405 | (37.735627364936, -122.502991257405) | 1 | 8 | 3 | 29491 | 35 | |||
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 | ||
24800 | 245572 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 560 27th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 2ft | 6002734.90719 | 2100089.37623 | 37.74660015789 | -122.43327502534 | (37.74660015789, -122.43327502534) | 2 | 7 | 5 | 63 | 22 | |||
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 | ||
25163 | 205432 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 925 Teresita Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5998667.60614 | 2095640.16467 | 37.7341521135345 | -122.447019141115 | (37.7341521135345, -122.447019141115) | 9 | 7 | 4 | 59 | 40 | |||
25177 | 245678 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 246 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003533.59792 | 2101587.45558 | 37.7507588109675 | -122.430620118738 | (37.7507588109675, -122.430620118738) | 2 | 4 | 5 | 28862 | 22 | |||
25225 | 117804 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3726 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5983955.54312 | 2111087.57325 | 37.7757148718468 | -122.499023527909 | (37.7757148718468, -122.499023527909) | 11 | 6 | 2 | 55 | 26 | |||
25448 | 205281 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 123 Ortega St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 2ft | 5993520.55231 | 2102533.14677 | 37.7527830913663 | -122.465314516263 | (37.7527830913663, -122.465314516263) | 1 | 8 | 4 | 29491 | 12 | |||
25452 | 205454 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 90 Monterey Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 8ft | 6001505.95732 | 2094694.47331 | 37.7317172188577 | -122.437138397743 | (37.7317172188577, -122.437138397743) | 9 | 7 | 4 | 63 | 40 | |||
25458 | 118164 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3640 Balboa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5984224.54908 | 2111096.57506 | 37.7757553640837 | -122.498093648535 | (37.7757553640837, -122.498093648535) | 11 | 6 | 2 | 55 | 26 | |||
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 | |
26166 | 245779 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 4 | Back Yard : Yard | Tree | Private 2 | 4 | Width 8ft | 6003578.06847 | 2096849.22804 | 37.73775125431 | -122.430128354157 | (37.73775125431, -122.430128354157) | 2 | 7 | 5 | 63 | 7 | |||
26211 | 31637 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2550 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 3x3 | Permit Number 767125 | 5981518.05011446 | 2097722.76963447 | 37.7388756474124 | -122.506463924771 | (37.7388756474124, -122.506463924771) | 1 | 8 | 3 | 29491 | 35 | |
26233 | 205431 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 965 Teresita Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5998412.37074 | 2095666.00705 | 37.7342084848239 | -122.447903426526 | (37.7342084848239, -122.447903426526) | 9 | 7 | 4 | 59 | 40 | |||
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 | ||
26502 | 126079 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2826 Broderick St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6000085.94786 | 2118320.10762 | 37.7965065168171 | -122.443744328262 | (37.7965065168171, -122.443744328262) | 13 | 9 | 1 | 57 | 17 | |||
26641 | 205408 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 190 Marietta Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5998852.43229 | 2097817.92525 | 37.7401422836322 | -122.446536768164 | (37.7401422836322, -122.446536768164) | 9 | 7 | 4 | 59 | 40 | |||
26820 | 175899 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 9 Prague St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6004990.6414 | 2091058.46133 | 37.7219309968925 | -122.424832548789 | (37.7219309968925, -122.424832548789) | 9 | 7 | 6 | 28861 | 5 |
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) );