Street_Tree_List

Data source: data.sfgov.org

1,824 rows where qSpecies = 47 sorted by Longitude

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
129 20398 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 262X Sunset Blvd 43 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60            
272 251264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
277 251265 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
293 251262 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
300 251263 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
549 251321 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 100X Monument Way 1 Unaccepted Street : Yard 14 Tree 1 Private 1                    
618 20377 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 262X Sunset Blvd 25 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 60            
682 251365 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1                    
712 251366 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1                    
713 251364 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1                    
886 19568 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY1 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 100ST            
1098 251438 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2501X Santiago St 1 Median : Yard 3 Tree 1 DPW 2                    
1898 20392 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 262X Sunset Blvd 38 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
5557 20407 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 262X Sunset Blvd 52 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
5855 19776 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY18 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 50ST            
6006 20312 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 101X Sunset Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60            
6023 19905 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY35 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 120ST            
6115 20296 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 20X Sunset Blvd 17 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
6147 19906 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY35 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 120ST            
6357 20291 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 20X Sunset Blvd 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            
6360 20424 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 453X Sunset Blvd 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
6399 20412 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 453X Sunset Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
6517 19907 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY35 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 120ST            
6533 19565 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY1 -11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 100ST            
6834 19955 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY39 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2ST            
6952 19935 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY38 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 10ST            
7006 20417 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 453X Sunset Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
7548 20317 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 101X Sunset Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            
7732 19948 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY39 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 25ST            
7834 119605 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 299x Avalon Ave 1 Front Yard : Yard 7 Tree 1 Private 1                    
7886 19945 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY39 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 25ST            
7938 19700 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY11 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 40ST            
8196 20297 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 20X Sunset Blvd 18 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
8406 20373 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 262X Sunset Blvd 21 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            
8739 20365 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 262X Sunset Blvd 15 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 60            
8750 20413 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 453X Sunset Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
8903 19566 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY1 -9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 100ST            
9072 19804 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY22 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 20            
9473 20455 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 495X Sunset Blvd 20 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
9584 20422 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 453X Sunset Blvd 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
10571 19570 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY1 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 100ST            
10674 19936 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY38 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 10ST            
10701 20452 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 495X Sunset Blvd 17 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
10705 19569 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY1 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 100ST            
10816 19910 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY35 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 120ST            
10949 19933 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY38 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 10ST            
11220 19950 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY39 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 25ST            
11591 20428 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 485X Sunset Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 40            
11826 20419 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 453X Sunset Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
12151 19869 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY33 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 25ST            
12480 20434 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 485X Sunset Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 30            
12812 19953 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY39 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 25ST            
13158 19753 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY15 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 10ST            
13184 20013 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY47 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 100ST            
14158 20429 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 485X Sunset Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 30            
14206 19813 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY24 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 100ST            
14400 19934 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY38 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 10ST            
14425 19694 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY7 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 12ST            
14506 20366 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 262X Sunset Blvd 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 60            
14521 20280 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 20X Sunset Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            
14597 20303 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 50X Sunset Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
14923 20430 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 485X Sunset Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 30            
14992 19932 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY38 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 10ST            
15767 19699 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY11 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 40ST            
15771 19908 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY35 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 120ST            
15978 19943 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY38 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 10ST            
16086 20423 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 453X Sunset Blvd 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
16424 19949 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY39 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 25ST            
16454 20294 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 20X Sunset Blvd 15 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60            
16608 19951 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY39 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 25ST            
16721 19947 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY39 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 25ST            
16878 19909 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY35 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 120ST            
17092 19978 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY45 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 30ST            
27191 186631 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1300 Lower Great Hwy 7 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980860.0426 2105683.7293 37.7606954284135 -122.50933003298901 (37.7606954284135, -122.509330032989)
73687 186630 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1300 Lower Great Hwy 6 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980860.7453 2105672.8381 37.7606655657469 -122.50932679385099 (37.7606655657469, -122.509326793851)
155462 186632 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1300 Lower Great Hwy 8 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5980861.0966 2105687.2426 37.7607051370684 -122.509326648666 (37.7607051370684, -122.509326648666)
137510 118414 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 641 48th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     26     5980997.21538 2111360.64896 37.7762906814163 -122.509277221064 (37.7762906814163, -122.509277221064)
174389 186633 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1300 Lower Great Hwy 9 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5980876.555 2105686.5399 37.760704119089 -122.509273133786 (37.760704119089, -122.509273133786)
153024 186626 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1300 Lower Great Hwy 2 unknown : Yard 19 Tree 1 Private 1     7 Width 0ft   5980879.19 2105650.5288 37.7606053983358 -122.509261346313 (37.7606053983358, -122.509261346313)
166154 186488 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1400 Lower Great Hwy 34 unknown : Yard 19 Tree 1 Private 1     15 Width 0ft   5980888.4423 2105382.2174 37.7598692379346 -122.50920942183998 (37.7598692379346, -122.50920942184)
185035 183344 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1210 48th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   5981199.4113 2106812.2909 37.763814137238896 -122.50824009998999 (37.7638141372389, -122.50824009999)
133209 183349 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1210 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   5981200.6659 2106791.7999 37.763757948803 -122.508234239743 (37.763757948803, -122.508234239743)
127792 99864 Permitted Site 1 Cupressus macrocarpa :: Monterey Cypress 47 681 47th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 768887 5981306.2 2111092.9 37.775573734396204 -122.508188499048 (37.7755737343962, -122.508188499048)
72965 99863 Permitted Site 1 Cupressus macrocarpa :: Monterey Cypress 47 681 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28     5981324.99313 2111098.19167 37.7755893711796 -122.508123883044 (37.7755893711796, -122.508123883044)
168002 118630 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 349 Point Lobos Ave 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     5981637.79887 2112651.0038099997 37.7798713628306 -122.507157052361 (37.7798713628306, -122.507157052361)
24438 118836 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 600 46th Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 3ft   5981651.25866 2111619.12831 37.77703893001029 -122.50703392298401 (37.7770389300103, -122.507033922984)
173594 118511 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 8131 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 6ft   5981763.277969999 2112328.08269 37.7789921064061 -122.506699014872 (37.7789921064061, -122.506699014872)
27465 118640 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 495 45th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   5981891.5492 2112442.21245 37.7793130253265 -122.50626374607401 (37.7793130253265, -122.506263746074)
155726 185138 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2690 Wawona St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 0ft   5982184.8279 2096764.5685 37.736283925183294 -122.504087599723 (37.7362839251833, -122.504087599723)
36295 176117 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 1 : 4 Tree 1 Private 1     27 Width 0ft   5982122.73417 2092919.02565 37.725721454959896 -122.50401753028099 (37.7257214549599, -122.504017530281)
140427 185137 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2690 Wawona St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     31 Width 0ft   5982222.13 2096764.5685 37.7362861187615 -122.503958633083 (37.7362861187615, -122.503958633083)
175790 176118 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 2 : 4 Tree 1 Private 1     9 Width 0ft   5982159.440219999 2092886.81947 37.7256351838922 -122.50388825816201 (37.7256351838922, -122.503888258162)
67613 176119 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 3 : 4 Tree 1 Private 1     6 Width 0ft   5982177.8802 2092874.78727 37.7256032309891 -122.503823622987 (37.7256032309891, -122.503823622987)
130304 185136 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2690 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     33 Width 0ft   5982268.7576 2096762.1144 37.7362821222461 -122.503797243162 (37.7362821222461, -122.503797243162)
60682 176120 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 5 : 4 Tree 1 Private 1     7 Width 0ft   5982240.010290001 2092829.2357299998 37.725481811732294 -122.503605476233 (37.7254818117323, -122.503605476233)
113704 24785 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 25 POINT LOBOS AVE 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   5982690.0 2112477.0 37.7794555150241 -122.50350419470301 (37.7794555150241, -122.503504194703)
43979 176121 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 8 : 4 Tree 1 Private 1     6 Width 0ft   5982310.611330001 2092790.70938 37.7253801793381 -122.503358567347 (37.7253801793381, -122.503358567347)
128242 176122 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 9 : 4 Tree 1 Private 1     3 Width 0ft   5982330.17471 2092783.08412 37.7253603924579 -122.50329037535101 (37.7253603924579, -122.503290375351)
40949 176127 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 14 : 4 Tree 1 Private 1     2 Width 0ft   5982331.987919999 2092758.60697 37.7252932913503 -122.503282295839 (37.7252932913503, -122.503282295839)
181416 176125 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 12 : 4 Tree 1 Private 1     2 Width 0ft   5982332.21205 2092769.0757400002 37.7253220489632 -122.50328229583499 (37.7253220489632, -122.503282295835)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 1103.231ms · Data source: data.sfgov.org