1,650 rows where qSpecies_id = 64 sorted by Neighborhoods (old)

View and edit SQL

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) ▼
1646 19899 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 100 STAIRWAY33 31 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
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                      
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                    
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                    
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                    
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                    
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                    
15929 20047 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 100 STAIRWAY52 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 10                      
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                    
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
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
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
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
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
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
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
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
28673 189353 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1151 Fairfax Ave 21 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6017759.87057 2096360.05037 37.7372010931465 -122.381060507862 (37.7372010931465, -122.381060507862) 10 3 8 58 1
37843 175909 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 200 Nueva Ave 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   6012814.5616 2086915.18102 37.7109931858583 -122.397496617385 (37.7109931858583, -122.397496617385) 10 3 8 309 1
38452 189333 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1427x Innes Ave 26 Median : Yard Tree DPW 1     18     6016146.37557 2096749.3676 37.7381808856511 -122.386666288817 (37.7381808856511, -122.386666288817) 10 3 8 58 1
40739 189335 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1427x Innes Ave 29 Median : Yard Tree DPW 1     15     6016137.08007 2096756.05642 37.7381987371688 -122.386698894633 (37.7381987371688, -122.386698894633) 10 3 8 58 1
41722 189381 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 25 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017800.88124 2096579.49396 37.7378059052205 -122.380933965155 (37.7378059052205, -122.380933965155) 10 3 8 58 1
44276 189389 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 40 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017682.88595 2096671.88866 37.7380530892708 -122.381348359258 (37.7380530892708, -122.381348359258) 10 3 8 58 1
45875 202071 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 98 Gould St 1 : Tree Private 2     4 Width 3ft   6012673.40671 2090736.38979 37.7214776018863 -122.398252411218 (37.7214776018863, -122.398252411218) 10 3 8 58 1
46234 201493 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 410 Hawes St 3 Sidewalk: Property side : Yard Tree Private 2     3     6018736.96879 2094929.02833 37.7333256725358 -122.377582915835 (37.7333256725358, -122.377582915835) 10 3 8 58 1
46426 29661 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 198X Cashmere St 4 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
47870 189323 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 301x Cashmere St 1 Median : Yard Tree DPW 1     6     6016365.09613 2096197.70243 37.7366782309168 -122.385871612795 (37.7366782309168, -122.385871612795) 10 3 8 58 1
48440 189386 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 34 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017728.94519 2096639.35373 37.7379662974982 -122.381186846422 (37.7379662974982, -122.381186846422) 10 3 8 58 1
48702 189322 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 299x Cashmere St 31 Median : Yard Tree DPW 1     2     6016409.15229 2096168.44158 37.736600324449 -122.385717251362 (37.736600324449, -122.385717251362) 10 3 8 58 1
49936 189354 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1151 Fairfax Ave 22 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6017754.93557 2096352.15892 37.7371791523904 -122.381077022089 (37.7371791523904, -122.381077022089) 10 3 8 58 1
52466 189366 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1188 Fairfax Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017781.98855 2096299.50337 37.7370360639635 -122.380979826963 (37.7370360639635, -122.380979826963) 10 3 8 58 1
52666 189345 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1151 Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6017780.12141 2096521.5523 37.7376456631085 -122.381001715564 (37.7376456631085, -122.381001715564) 10 3 8 58 1
57494 189367 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1188 Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017784.81791 2096314.09412 37.7370762834315 -122.380971058572 (37.7370762834315, -122.380971058572) 10 3 8 58 1
59321 175910 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 256 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6012412.28873 2087359.88016 37.7121918346656 -122.398918168549 (37.7121918346656, -122.398918168549) 10 3 8 309 1
59726 189379 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 22 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6017817.80282 2096554.03386 37.7377369308132 -122.38087368899 (37.7377369308132, -122.38087368899) 10 3 8 58 1
67804 189329 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1427x Innes Ave 22 Median : Yard Tree DPW 1     22     6016170.50674 2096734.91499 37.7381425376441 -122.386581846976 (37.7381425376441, -122.386581846976) 10 3 8 58 1
68323 189358 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1100 Fairfax Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6017825.61264 2096067.48761 37.736401402503 -122.380812873212 (37.736401402503, -122.380812873212) 10 3 8 58 1
70402 189371 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6017827.39616 2096381.99519 37.7372650763112 -122.380828563686 (37.7372650763112, -122.380828563686) 10 3 8 58 1
72134 189324 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1427x Innes Ave 13 Median : Yard Tree DPW 1     4     6016254.7178 2096666.03631 37.7379580722924 -122.386285883701 (37.7379580722924, -122.386285883701) 10 3 8 58 1
73136 189342 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1195 Fairfax Ave 12 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6017737.91821 2096573.15681 37.7377850292651 -122.381151220665 (37.7377850292651, -122.381151220665) 10 3 8 58 1
76937 189321 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 299x Cashmere St 30 Median : Yard Tree DPW 1     7     6016453.45941 2096140.51631 37.7365260988976 -122.38556211562 (37.7365260988976, -122.38556211562) 10 3 8 58 1
80298 189316 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1089 Jamestown Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3     6013485.95319 2089984.75612 37.7194589935203 -122.395391011311 (37.7194589935203, -122.395391011311) 10 3 8 58 1
80688 189369 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6017814.97814 2096356.1819 37.7371935127733 -122.380869704969 (37.7371935127733, -122.380869704969) 10 3 8 58 1
83280 175904 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 300 Blanken Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6012465.00059 2087095.54364 37.7114689560088 -122.398717440763 (37.7114689560088, -122.398717440763) 10 3 8 309 1
83966 29660 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 198X Cashmere St 3 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
84448 189370 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6017823.73172 2096374.95367 37.737245539451 -122.380840744109 (37.737245539451, -122.380840744109) 10 3 8 58 1
86494 202072 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 98 Gould St 2 : Tree Private 2     11 Width 3ft   6012663.72375 2090703.30788 37.7213862262721 -122.398283562861 (37.7213862262721, -122.398283562861) 10 3 8 58 1
86948 189373 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6017841.36769 2096447.46788 37.7374456224015 -122.380784807191 (37.7374456224015, -122.380784807191) 10 3 8 58 1
87273 201492 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 410 Hawes St 2 Sidewalk: Property side : Yard Tree Private 2     9     6018741.78505 2094936.24141 37.7333457436025 -122.377566764894 (37.7333457436025, -122.377566764894) 10 3 8 58 1
88804 189332 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1427x Innes Ave 25 Median : Yard Tree DPW 1     5     6016155.51714 2096746.87389 37.7381745445247 -122.386634507683 (37.7381745445247, -122.386634507683) 10 3 8 58 1
89356 98812 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 290 Napoleon St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6011936.39142 2099770.08858 37.7462411674082 -122.401434638901 (37.7462411674082, -122.401434638901) 10 3 8 58 1
90586 189362 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1100 Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6017812.44528 2096136.32972 37.7365897025526 -122.380863183095 (37.7365897025526, -122.380863183095) 10 3 8 58 1
90613 189341 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1195 Fairfax Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017727.65109 2096582.91421 37.7378112543843 -122.381187397677 (37.7378112543843, -122.381187397677) 10 3 8 58 1
91754 189336 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1195 Fairfax Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6017658.40577 2096642.73711 37.737971693433 -122.381430973671 (37.737971693433, -122.381430973671) 10 3 8 58 1
92152 189388 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 37 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017704.60452 2096656.13327 37.7380110270928 -122.381272171384 (37.7380110270928, -122.381272171384) 10 3 8 58 1
92797 29662 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 198X Cashmere St 5 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
92831 29656 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 190X Cashmere St 1 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 3X3   6016261.8205744 2096260.7089353 37.7368455183428 -122.386233075665 (37.7368455183428, -122.386233075665) 10 3 8 58 1
93177 189385 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 32 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6017746.74315 2096627.19057 37.7379338823466 -122.381124464031 (37.7379338823466, -122.381124464031) 10 3 8 58 1
95266 189327 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1427x Innes Ave 20 Median : Yard Tree DPW 1     24     6016185.54998 2096725.46158 37.7381174132775 -122.386529175505 (37.7381174132775, -122.386529175505) 10 3 8 58 1
97762 189357 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1101 Fairfax Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6017772.7039 2096095.52292 37.736475461683 -122.380997751349 (37.736475461683, -122.380997751349) 10 3 8 58 1
105972 201491 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 410 Hawes St 1 Sidewalk: Property side : Yard Tree Private 2     9     6018753.58694 2094959.04146 37.7334089983181 -122.377527543687 (37.7334089983181, -122.377527543687) 10 3 8 58 1
107443 189365 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1188 Fairfax Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017781.37982 2096281.83738 37.7369875230661 -122.380980703818 (37.7369875230661, -122.380980703818) 10 3 8 58 1
107771 189347 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1151 Fairfax Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017789.20409 2096498.15859 37.7375819299621 -122.380968686163 (37.7375819299621, -122.380968686163) 10 3 8 58 1
109746 54767 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 198 Nueva Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/1972 12:00:00 AM 7 3x3 Permit Number 10616 6012845.85571 2087036.62523 37.7113283901643 -122.397396968017 (37.7113283901643, -122.397396968017) 10 3 8 309 1
110514 189338 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1195 Fairfax Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6017678.6127 2096626.66262 37.7379286716701 -122.381359990186 (37.7379286716701, -122.381359990186) 10 3 8 58 1
112467 175906 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 185 Nueva Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6012910.66172 2087085.51703 37.7114662454497 -122.39717640659 (37.7114662454497, -122.39717640659) 10 3 8 309 1
115824 189387 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 36 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6017709.84624 2096650.65154 37.7379962647187 -122.381253666927 (37.7379962647187, -122.381253666927) 10 3 8 58 1
120200 189320 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 122 Whitney Young Cir 7 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6016428.13568 2095859.36689 37.7357527179215 -122.385630082783 (37.7357527179215, -122.385630082783) 10 3 8 58 1
124041 175901 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 300 Blanken Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6012404.40104 2087114.75356 37.7115183260741 -122.398928237353 (37.7115183260741, -122.398928237353) 10 3 8 309 1
124507 189374 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 13 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017842.42691 2096472.87377 37.7375154403828 -122.380782910515 (37.7375154403828, -122.380782910515) 10 3 8 58 1
128306 202036 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 74 Crane St 1 : Tree Private 2     12 Width 4ft   6012239.5705 2090921.68995 37.7219622231619 -122.399765078106 (37.7219622231619, -122.399765078106) 10 3 8 58 1
128421 189360 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1100 Fairfax Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6017818.67365 2096093.95102 37.7364736828066 -122.380838703567 (37.7364736828066, -122.380838703567) 10 3 8 58 1
131322 189340 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1195 Fairfax Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017708.86017 2096602.39431 37.7378637055476 -122.381253721795 (37.7378637055476, -122.381253721795) 10 3 8 58 1
132408 189331 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1427x Innes Ave 24 Median : Yard Tree DPW 1     25     6016158.58159 2096743.10155 37.7381643560956 -122.386623649267 (37.7381643560956, -122.386623649267) 10 3 8 58 1
133239 189350 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1151 Fairfax Ave 17 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6017779.96629 2096390.27797 37.7372852013503 -122.380993127945 (37.7372852013503, -122.380993127945) 10 3 8 58 1
133400 189363 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1100 Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017807.80075 2096153.39811 37.7366363126207 -122.380880427608 (37.7366363126207, -122.380880427608) 10 3 8 58 1
137651 189380 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 23 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6017813.34162 2096563.52583 37.7377627476478 -122.380889773354 (37.7377627476478, -122.380889773354) 10 3 8 58 1
139054 189355 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1151 Fairfax Ave 24 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6017745.1188 2096339.03807 37.7371425832692 -122.381110051504 (37.7371425832692, -122.381110051504) 10 3 8 58 1
139074 189361 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1100 Fairfax Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017812.68284 2096124.68728 37.7365577478341 -122.380861552625 (37.7365577478341, -122.380861552625) 10 3 8 58 1
140767 189383 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 29 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6017772.50724 2096612.75637 37.7378956710501 -122.381034380748 (37.7378956710501, -122.381034380748) 10 3 8 58 1
141538 175902 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 300 Blanken Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6012419.93786 2087109.24403 37.7115040637341 -122.398874151239 (37.7115040637341, -122.398874151239) 10 3 8 309 1
148150 189314 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1599 Rankin St 1 Sidewalk: Property side : Yard Tree Private 2     13     6012500.67286 2096438.13487 37.7371237964252 -122.399249555236 (37.7371237964252, -122.399249555236) 10 3 8 58 1
148561 175908 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 200 Nueva Ave 2 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6012813.7614 2086935.46325 37.7110488323118 -122.39750080462 (37.7110488323118, -122.39750080462) 10 3 8 309 1
150718 189311 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1763 Revere Ave 2 : Tree Private 2     19 Width 3ft   6014243.98109 2094996.62918 37.7332627209035 -122.393121267238 (37.7332627209035, -122.393121267238) 10 3 8 58 1
153114 189368 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1188 Fairfax Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017798.12742 2096332.7671 37.737128290339 -122.380926338881 (37.737128290339, -122.380926338881) 10 3 8 58 1
154953 175903 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 300 Blanken Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6012445.87825 2087102.32465 37.7114865098748 -122.398784008572 (37.7114865098748, -122.398784008572) 10 3 8 309 1
155001 201494 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 410 Hawes St 4 Sidewalk: Property side : Yard Tree Private 2     8     6018722.25822 2094905.40037 37.7332599842609 -122.377632135729 (37.7332599842609, -122.377632135729) 10 3 8 58 1
155269 189377 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 18 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6017833.99487 2096515.69962 37.7376325662831 -122.380815040593 (37.7376325662831, -122.380815040593) 10 3 8 58 1
155638 189382 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1190 Fairfax Ave 27 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6017785.19971 2096595.68111 37.7378494863677 -122.38098930943 (37.7378494863677, -122.38098930943) 10 3 8 58 1
155777 189319 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1121 Jamestown Ave 13 Sidewalk: Curb side : Yard Tree Private 2     6     6013379.93959 2090055.27551 37.7196467287812 -122.395762402515 (37.7196467287812, -122.395762402515) 10 3 8 58 1
156074 189309 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 43 Robblee Ave 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 5ft   6012560.50299 2095900.61555 37.7356512150331 -122.399004977414 (37.7356512150331, -122.399004977414) 10 3 8 58 1
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
156445 189352 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1151 Fairfax Ave 20 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017765.14956 2096366.03264 37.737217810659 -122.381042671585 (37.737217810659, -122.381042671585) 10 3 8 58 1
156643 189356 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1101 Fairfax Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017759.84032 2096158.94756 37.7366489031225 -122.381046634905 (37.7366489031225, -122.381046634905) 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
157254 189312 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1784 Revere Ave 2 : Tree Private 2     3 Width 5ft   6014126.96822 2095142.52205 37.733656811898 -122.393536022869 (37.733656811898, -122.393536022869) 10 3 8 58 1
159674 189315 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 235 Bridgeview Dr 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 6ft   6013011.47029 2095413.8062 37.7343396572314 -122.397411670132 (37.7343396572314, -122.397411670132) 10 3 8 58 1
159687 189364 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1100 Fairfax Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017803.09649 2096176.66908 37.7366999504426 -122.380898309728 (37.7366999504426, -122.380898309728) 10 3 8 58 1
167020 189317 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1015 Jamestown Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4     6013888.25038 2089668.52955 37.7186130651163 -122.393978282498 (37.7186130651163, -122.393978282498) 10 3 8 58 1

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);