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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
393 | 182533 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1581 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5985582.1491 | 2104457.0825 | 37.7576046859901 | -122.492908268983 | (37.7576046859901, -122.492908268983) | 1 | 8 | 3 | 56 | 35 | |||
512 | 126120 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2843 Larkin St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6006458.53093 | 2121044.25925 | 37.8043477551992 | -122.421887372509 | (37.8043477551992, -122.421887372509) | 5 | 9 | 1 | 28858 | 32 | |||
577 | 205386 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 Rosewood Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5994512.47364 | 2095959.37509 | 37.7347903147287 | -122.461407773158 | (37.7347903147287, -122.461407773158) | 9 | 8 | 4 | 59 | 40 | |||
603 | 245637 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 111 Manchester St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6008273.00792 | 2099308.43984 | 37.7447685005688 | -122.414069557873 | (37.7447685005688, -122.414069557873) | 2 | 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 | ||
804 | 175950 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 326 Avalon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6003638.04232 | 2092697.69928 | 37.7263554895976 | -122.42962499282 | (37.7263554895976, -122.42962499282) | 9 | 7 | 6 | 28861 | 5 | |||
990 | 245607 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 263 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007571 | 2097463 | 37.7396618784985 | -122.416366286166 | (37.7396618784985, -122.416366286166) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
1454 | 247689 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2 Central Ave | 4 | : | Tree | Private 2 | 24 | Width 4ft | 5999999.2126 | 2108392.11953 | 37.7692418764422 | -122.443330996248 | (37.7692418764422, -122.443330996248) | 15 | 5 | 11 | 29492 | 9 | |||
1646 | 19899 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 STAIRWAY33 | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
1650 | 126124 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1055 Lombard St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6007293.98833 | 2120181.06921 | 37.8020247344007 | -122.418934936917 | (37.8020247344007, -122.418934936917) | 5 | 1 | 1 | 28858 | 32 | |||
1739 | 189348 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017793.1763 | 2096477.15047 | 37.7375244650907 | -122.380953492111 | (37.7375244650907, -122.380953492111) | 10 | 3 | 8 | 58 | 1 | |||
1819 | 259562 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 200 Public Park | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994204 | 2098512 | 37.741781429361 | -122.462659374294 | (37.741781429361, -122.462659374294) | 1 | 8 | 4 | 59 | 40 | ||||
1926 | 205350 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1500 Ulloa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991278.78749 | 2098428.09247 | 37.7413821375847 | -122.47276757848 | (37.7413821375847, -122.47276757848) | 1 | 8 | 4 | 29491 | 40 | |||
1960 | 189303 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1345 20th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013928.16034 | 2104751.39428 | 37.7600296962246 | -122.394896108974 | (37.7600296962246, -122.394896108974) | 10 | 3 | 8 | 28856 | 29 | |||
1995 | 87953 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 495 Harkness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50978 | 6010151 | 2089645.9 | 37.7183425147467 | -122.406894902171 | (37.7183425147467, -122.406894902171) | 10 | 7 | 8 | 309 | 39 | ||
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 | |||
2127 | 205363 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 250 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5994757.66633 | 2100420.78741 | 37.7470543532783 | -122.460883300235 | (37.7470543532783, -122.460883300235) | 1 | 8 | 4 | 29491 | 40 | |||
2193 | 182215 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2998 Lawton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985108.0649 | 2104343.6089 | 37.7572653833543 | -122.494539455696 | (37.7572653833543, -122.494539455696) | 1 | 8 | 3 | 56 | 35 | |||
2365 | 97086 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4550 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2020 12:00:00 AM | 3 | 3x3 | 5981457.56361 | 2110998.49669 | 37.7753234489943 | -122.507657898162 | (37.7753234489943, -122.507657898162) | 11 | 6 | 2 | 55 | 26 | ||
2481 | 245485 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1300 San Jose Ave | 72 | Front Yard : Yard | Tree | Private 2 | 4 | Width 5ft | 6003516.63487 | 2095667.30987 | 37.7345024965788 | -122.430256461687 | (37.7345024965788, -122.430256461687) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||
3030 | 205255 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1948 16th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 1ft | 5991290.8698 | 2102154.62063 | 37.7516149197081 | -122.47299748747 | (37.7516149197081, -122.47299748747) | 1 | 8 | 4 | 29491 | 12 | |||
3163 | 245541 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 499X Ogden Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6008320.69019 | 2096092.37783 | 37.7359405790823 | -122.413677250212 | (37.7359405790823, -122.413677250212) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
3380 | 261217 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3400 Vicente St | : Cutout | Tree | Private 2 | FUF | 3x3 | 5982420.06104 | 2097439.60235 | 37.738151214353 | -122.503324281602 | (37.738151214353, -122.503324281602) | 1 | 8 | 3 | 29491 | 35 | ||||
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 | |||||||||||||
3460 | 20048 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 STAIRWAY52 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
3547 | 71714 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3725 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 3x6 | Permit Number 771233 | 5984016.25098 | 2111031.53375 | 37.7755645644081 | -122.498809386612 | (37.7755645644081, -122.498809386612) | 11 | 6 | 2 | 55 | 26 | |
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 | |||
3731 | 175896 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 529 Lisbon St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6002023.9515 | 2090409.71529 | 37.7199816731933 | -122.435041255167 | (37.7199816731933, -122.435041255167) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
4138 | 175926 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 207 San Juan Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6001151.19668 | 2092294.37303 | 37.7251069212337 | -122.438193002116 | (37.7251069212337, -122.438193002116) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||||||||||||
4344 | 245567 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 916 Elizabeth St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 39 | Width 4ft | 6000500.80489 | 2102003.5265 | 37.7517289609205 | -122.441137602835 | (37.7517289609205, -122.441137602835) | 2 | 4 | 5 | 28862 | 22 | |||
4394 | 261156 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4221 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/2020 12:00:00 AM | 3 | 3x3 | 5981166 | 2103448 | 37.7545747897022 | -122.508105942328 | (37.7545747897022, -122.508105942328) | 1 | 8 | 3 | 56 | 35 | |
4396 | 260248 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Copper Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999810 | 2103933 | 37.7569874509855 | -122.443665087987 | (37.7569874509855, -122.443665087987) | 2 | 5 | 5 | 28862 | 3 | ||||
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 | ||||
4755 | 245512 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 106 Chattanooga St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 4ft | 6004701.89686 | 2103004.13948 | 37.7547148117622 | -122.426680909207 | (37.7547148117622, -122.426680909207) | 2 | 4 | 5 | 28862 | 22 | |||
4894 | 182443 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1530 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985305.1982 | 2104772.3112 | 37.7584540168422 | -122.493889294148 | (37.7584540168422, -122.493889294148) | 1 | 8 | 3 | 56 | 35 | |||
5331 | 236694 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4515 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6000927.42532 | 2101109.44897 | 37.7492983299761 | -122.439598207206 | (37.7492983299761, -122.439598207206) | 2 | 4 | 5 | 28862 | 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 | ||
5453 | 189384 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017757.64488 | 2096623.78425 | 37.737925131039 | -122.381086534243 | (37.737925131039, -122.381086534243) | 10 | 3 | 8 | 58 | 1 | |||
5542 | 117796 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3739 Balboa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5983953.06795 | 2111029.92822 | 37.7755564500477 | -122.49902782995 | (37.7755564500477, -122.49902782995) | 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 | |||
6119 | 245606 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 269 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6007569 | 2097440 | 37.7395986131129 | -122.416371572654 | (37.7395986131129, -122.416371572654) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
6229 | 54527 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4550 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2020 12:00:00 AM | 3 | 3x5 | Permit Number 10322 | 5981462.67511 | 2111006.65453 | 37.775346149152 | -122.507640822085 | (37.775346149152, -122.507640822085) | 11 | 6 | 2 | 55 | 26 | |
6700 | 118852 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 518 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5981326.91116 | 2112159.50224 | 37.7785035297781 | -122.508196040224 | (37.7785035297781, -122.508196040224) | 11 | 6 | 2 | 55 | 26 | |||
6872 | 245755 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1116 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002482.91407 | 2102267.39959 | 37.7525661964955 | -122.434302077201 | (37.7525661964955, -122.434302077201) | 2 | 4 | 5 | 28862 | 22 | |||
7266 | 245758 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 220 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 2ft | 6004895.76368 | 2096843.93184 | 37.7378112552963 | -122.425572065806 | (37.7378112552963, -122.425572065806) | 2 | 7 | 5 | 63 | 7 | |||
7328 | 182420 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1550 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5985930.8682 | 2104662.5204 | 37.7581891485667 | -122.491717396551 | (37.7581891485667, -122.491717396551) | 1 | 8 | 3 | 56 | 35 | |||
7749 | 118166 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3232 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5985500.8537 | 2111144.01692 | 37.7759603747412 | -122.493682150646 | (37.7759603747412, -122.493682150646) | 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 | |||
7958 | 258015 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1267 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5983961.07451 | 2106546.41289 | 37.7632464670432 | -122.498668855343 | (37.7632464670432, -122.498668855343) | 1 | 8 | 3 | 56 | 35 | |||
7959 | 205335 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 134 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5991702.38493 | 2089452.42364 | 37.7167617027762 | -122.470649341406 | (37.7167617027762, -122.470649341406) | 9 | 8 | 6 | 64 | 24 | |||
8032 | 245760 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 127 Farnum St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6002444.1806 | 2097361.0891 | 37.7390924204823 | -122.43408532709 | (37.7390924204823, -122.43408532709) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||
8653 | 254419 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3400X Moraga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781063 | ||||||||||
8902 | 89579 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4801X Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983739.98456 | 2111706.68293 | 37.777402120963 | -122.499814958061 | (37.777402120963, -122.499814958061) | 11 | 6 | 2 | 55 | 26 | ||
9042 | 122353 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 155 Appleton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
9061 | 245544 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2020 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6008037.51998 | 2106722.39009 | 37.7651122930328 | -122.415408600746 | (37.7651122930328, -122.415408600746) | 8 | 4 | 7 | 28859 | 19 | |||
9111 | 29980 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1622X Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005918.53507 | 2099515.50587 | 37.7452045332674 | -122.422225595834 | (37.7452045332674, -122.422225595834) | 2 | 7 | 5 | 28859 | 2 | ||
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 | ||||
9201 | 205370 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 251 Wildwood Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995666.31716 | 2093292.13058 | 37.7275330492907 | -122.457225677447 | (37.7275330492907, -122.457225677447) | 9 | 7 | 4 | 28861 | 40 | |||
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 | |
9532 | 261191 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 599x Benton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007159 | 2095436 | 37.7340730065148 | -122.41764717788 | (37.7340730065148, -122.41764717788) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||||||||||||
10077 | 264701 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 88 Entrada Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8x20 | 5992483 | 2092113 | 37.724112106281 | -122.468144593972 | (37.724112106281, -122.468144593972) | 9 | 8 | 4 | 59 | 40 | ||||
10351 | 71636 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3710 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 3x6 | Permit Number 771232 | 5984058.85171 | 2111091.8464 | 37.7757326640871 | -122.498666479041 | (37.7757326640871, -122.498666479041) | 11 | 6 | 2 | 55 | 26 | |
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 | |||
10829 | 245757 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1884 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004576.62382 | 2097711.65254 | 37.7401757815964 | -122.426737263435 | (37.7401757815964, -122.426737263435) | 2 | 7 | 5 | 63 | 7 | |||
10877 | 205247 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1436 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2002 12:00:00 AM | 7 | Width 3ft | Permit Number 45929 | 5990862.22967 | 2105614.49151 | 37.7610899852431 | -122.474732265294 | (37.7610899852431, -122.474732265294) | 1 | 8 | 4 | 56 | 12 | |
10994 | 189372 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017835.15635 | 2096405.7352 | 37.7373306899522 | -122.380803382685 | (37.7373306899522, -122.380803382685) | 10 | 3 | 8 | 58 | 1 | |||
11153 | 205453 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 142 Monterey Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6001121.86387 | 2094702.03359 | 37.7317161369712 | -122.438466824999 | (37.7317161369712, -122.438466824999) | 9 | 7 | 4 | 63 | 40 | |||
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 | |||
11211 | 256751 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1858 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 5985068.08912 | 2102552.26769 | 37.7523445150231 | -122.494545652262 | (37.7523445150231, -122.494545652262) | 1 | 8 | 3 | 56 | 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 | ||||
11556 | 253426 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2 09th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780637 | 5993083 | 2114893 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | 11 | 6 | 1 | 54 | 11 | |
11609 | 245630 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 53 Appleton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005628.85756 | 2097048.73767 | 37.7384150016563 | -122.42305195408 | (37.7384150016563, -122.42305195408) | 2 | 7 | 7 | 28859 | 2 | |||
11802 | 261531 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 44th Ave | 2 | 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 | ||
11847 | 118142 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3404 Balboa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5985014.87745 | 2111125.50759 | 37.7758811108771 | -122.495361878931 | (37.7758811108771, -122.495361878931) | 11 | 6 | 2 | 55 | 26 | |||
12007 | 205264 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1050 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991629.32312 | 2105245.37395 | 37.7601209063813 | -122.472052340447 | (37.7601209063813, -122.472052340447) | 1 | 8 | 4 | 56 | 12 | |||
12123 | 189376 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017838.12886 | 2096499.84024 | 37.7375892477372 | -122.380799645108 | (37.7375892477372, -122.380799645108) | 10 | 3 | 8 | 58 | 1 | |||
12196 | 175980 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 967 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001586.84738 | 2086770.85375 | 37.7099653381068 | -122.436291887471 | (37.7099653381068, -122.436291887471) | 9 | 7 | 6 | 28861 | 5 | |||
12337 | 89570 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4935 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983308.7395 | 2111690.55403 | 37.77733251999 | -122.501305558655 | (37.77733251999, -122.501305558655) | 11 | 6 | 2 | 55 | 26 | ||
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 | ||
12789 | 109729 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 4534 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774273 | 6000926.1 | 2104675 | 37.7590883953394 | -122.439858400707 | (37.7590883953394, -122.439858400707) | 2 | 4 | 5 | 28862 | 3 |
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) );