trees
1,650 rows where qSpecies_id = 64 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
149194 | 89568 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4939 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983374.388584 | 2111699.374735 | 37.7773605941443 | -122.501079113369 | (37.7773605941443, -122.501079113369) | 11 | 6 | 2 | 55 | 26 | |
152762 | 245666 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681x San Jose Ave | 2 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005857.27695 | 2099307.63569 | 37.744630313449 | -122.422422649005 | (37.744630313449, -122.422422649005) | 2 | 7 | 5 | 28859 | 2 | |||
155456 | 5007 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5300 Diamond Heights Blvd | 24 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.7435139095193 | -122.437744874344 | (37.7435139095193, -122.437744874344) | 2 | 7 | 5 | 63 | 7 | |||
156086 | 189328 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 21 | Median : Yard | Tree | DPW 1 | 13 | 6016180.04891 | 2096728.46226 | 37.7381253480046 | -122.386548404801 | (37.7381253480046, -122.386548404801) | 10 | 3 | 8 | 58 | 1 | ||||
157061 | 189325 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 17 | Median : Yard | Tree | DPW 1 | 6 | 6016204.94299 | 2096703.88094 | 37.7380592307576 | -122.386460619275 | (37.7380592307576, -122.386460619275) | 10 | 3 | 8 | 58 | 1 | ||||
157541 | 89535 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5140 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982632.30275 | 2111719.79909 | 37.7773730709909 | -122.503647700164 | (37.7773730709909, -122.503647700164) | 11 | 6 | 2 | 55 | 26 | ||
159247 | 30008 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750X San Jose Ave | 4 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005682.80795 | 2098743.37668 | 37.7430711426298 | -122.422985832334 | (37.7430711426298, -122.422985832334) | 2 | 7 | 7 | 28859 | 2 | ||
161251 | 205331 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1x Minerva St | 30 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5996300.38931 | 2089001.53161 | 37.7157884744382 | -122.454723843541 | (37.7157884744382, -122.454723843541) | 9 | 8 | 6 | 28861 | 24 | |||
161264 | 89584 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4701X Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984050.86034 | 2111716.58833 | 37.7774475561944 | -122.498740285508 | (37.7774475561944, -122.498740285508) | 11 | 6 | 2 | 55 | 26 | ||
161915 | 89554 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5301X Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982173.17195 | 2111648.65895 | 37.7771507360561 | -122.50523068261 | (37.7771507360561, -122.50523068261) | 11 | 6 | 2 | 55 | 26 | ||
162380 | 245664 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 738x San Jose Ave | 3 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005721.51625 | 2098863.78747 | 37.7434039475413 | -122.42286054508 | (37.7434039475413, -122.42286054508) | 2 | 7 | 7 | 28859 | 2 | |||
163068 | 30010 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750X San Jose Ave | 2 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005675.35784 | 2098723.21181 | 37.7430153540666 | -122.423010159912 | (37.7430153540666, -122.423010159912) | 2 | 7 | 7 | 28859 | 2 | ||
165118 | 1599 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 716 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5995690.04192 | 2111213.1613 | 37.7767410460082 | -122.458440325737 | (37.7767410460082, -122.458440325737) | 11 | 6 | 2 | 54 | 16 | |||
174766 | 126129 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2800x Van Ness Ave | 5 | Median : Cutout | Tree | DPW 1 | 5 | Width 6ft | 6005644.09156 | 2120125.76706 | 37.8017798472085 | -122.424640432904 | (37.8017798472085, -122.424640432904) | 5 | 9 | 1 | 28858 | 32 | |||
174996 | 89573 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4901X Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983409.0007 | 2111692.01023 | 37.7773424056819 | -122.50095883592 | (37.7773424056819, -122.50095883592) | 11 | 6 | 2 | 55 | 26 | ||
175723 | 30013 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 738X San Jose Ave | 5 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005738.10231 | 2098921.33618 | 37.7435628991021 | -122.422807283651 | (37.7435628991021, -122.422807283651) | 2 | 7 | 7 | 28859 | 2 | ||
176370 | 189334 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 27 | Median : Yard | Tree | DPW 1 | 17 | 6016143.04506 | 2096752.08346 | 37.7381881584664 | -122.386677993501 | (37.7381881584664, -122.386677993501) | 10 | 3 | 8 | 58 | 1 | ||||
180244 | 245673 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1594x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005908.33244 | 2099840.79063 | 37.7460971157901 | -122.422283981647 | (37.7460971157901, -122.422283981647) | 2 | 7 | 5 | 28859 | 22 | |||
180733 | 27694 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 600X El Camino Del Mar | 8 | Median : Cutout | Tree | DPW 1 | 3 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
182486 | 20801 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1792X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.495403216296 | (37.7535582155387, -122.495403216296) | 1 | 8 | 3 | 56 | 35 | |||
182904 | 29658 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198X Cashmere St | 1 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806342 | 37.7367893783748 | -122.386594949018 | (37.7367893783748, -122.386594949018) | 10 | 3 | 8 | 58 | 1 | ||
183505 | 205330 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1x Minerva St | 26 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5996263.21296 | 2089001.74294 | 37.715786922213 | -122.45485235667 | (37.715786922213, -122.45485235667) | 9 | 8 | 6 | 28861 | 24 | |||
184633 | 90728 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4641 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981176.26351 | 2110250.76808 | 37.7732538301583 | -122.50857544098 | (37.7732538301583, -122.50857544098) | 11 | 6 | 2 | 55 | 26 | ||
185788 | 29996 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 10 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005885.11752 | 2099395.68964 | 37.7448736601053 | -122.422332636749 | (37.7448736601053, -122.422332636749) | 2 | 7 | 5 | 28859 | 2 | ||
189073 | 89517 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4800X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983737.26979 | 2111759.81457 | 37.7775478457233 | -122.499828277362 | (37.7775478457233, -122.499828277362) | 11 | 6 | 2 | 55 | 26 | ||
190062 | 29993 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 8 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005880.60295 | 2099381.42021 | 37.7448342248263 | -122.422347233647 | (37.7448342248263, -122.422347233647) | 2 | 7 | 5 | 28859 | 2 | ||
191803 | 29985 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 688X San Jose Ave | 1 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005799.98017 | 2099121.4011 | 37.7441157231568 | -122.422607538818 | (37.7441157231568, -122.422607538818) | 2 | 7 | 5 | 28859 | 2 | ||
192344 | 29659 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198X Cashmere St | 2 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806342 | 37.7367893783748 | -122.386594949018 | (37.7367893783748, -122.386594949018) | 10 | 3 | 8 | 58 | 1 | ||
194445 | 24428 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1501 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1995 12:00:00 AM | 3 | 3X3 | 6005809.51077 | 2115255.80256 | 37.7884174936216 | -122.42372154163 | (37.7884174936216, -122.42372154163) | 13 | 9 | 1 | 28858 | 41 | ||
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 | |||
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 | |||
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 | |||||||||||||
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 | |||
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 | |||
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 | ||||||||||
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 | |||
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 |
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) );