Street_Tree_List

Data source: data.sfgov.org

73 rows where qSpecies = 81 sorted by TreeID

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes

Link rowid TreeID ▼ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
7948 6357 Permitted Site 1 Platanus racemosa :: California Sycamore 81 2020X Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/14/2012 12:00:00 AM 12 4X4 Permit Number 768573 6001173.6622 2112841.531 37.781525742569606 -122.439587660215 (37.7815257425696, -122.439587660215)
4100 6358 Permitted Site 1 Platanus racemosa :: California Sycamore 81 2020X Ellis St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/14/2012 12:00:00 AM 12 4X4 Permit Number 768573 6001159.1101 2112838.4852 37.781516551338704 -122.43963778496 (37.7815165513387, -122.43963778496)
21160 22965 Permitted Site 1 Platanus racemosa :: California Sycamore 81 522 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3X3   6006140.66017 2106547.90509 37.7645264017829 -122.42195698992201 (37.7645264017829, -122.421956989922)
17151 22968 Permitted Site 1 Platanus racemosa :: California Sycamore 81 572 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/04/2010 12:00:00 AM 3 3x3   6006154.71472 2106264.74945 37.763749715787796 -122.421888263744 (37.7637497157878, -122.421888263744)
23261 22995 DPW Maintained 3 Platanus racemosa :: California Sycamore 81 692 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/13/2017 12:00:00 AM 7 3X6   6006189.8131800005 2105598.89712 37.7619234211376 -122.42171957161699 (37.7619234211376, -122.421719571617)
23100 22998 DPW Maintained 3 Platanus racemosa :: California Sycamore 81 714 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/1994 12:00:00 AM 8     6006205.20873 2105402.95089 37.7613862668816 -122.421652406646 (37.7613862668816, -122.421652406646)
672 23002 Permitted Site 1 Platanus racemosa :: California Sycamore 81 742 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/1994 12:00:00 AM 20 3X3   6006210.140269999 2105247.24413 37.7609590106658 -122.421624291141 (37.7609590106658, -122.421624291141)
19364 23004 DPW Maintained 3 Platanus racemosa :: California Sycamore 81 762 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 3X3   6006215.9045 2105176.06867 37.760763904540894 -122.42159929989401 (37.7607639045409, -122.421599299894)
20744 23006 Permitted Site 1 Platanus racemosa :: California Sycamore 81 766 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/23/1994 12:00:00 AM 8 3X3   6006218.84128 2105121.1414400004 37.7606132528131 -122.421585241678 (37.7606132528131, -122.421585241678)
168318 70648 Undocumented 2 Platanus racemosa :: California Sycamore 81 239 Vienna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/06/1994 12:00:00 AM 7     6004288.7476699995 2092010.61731 37.7245057379221 -122.42732661165701 (37.7245057379221, -122.427326611657)
1517 99716 Private 5 Platanus racemosa :: California Sycamore 81 1415 Scott St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6001693.2243 2113487.1552 37.7833280195253 -122.43783648412202 (37.7833280195253, -122.437836484122)
100459 108658 Permitted Site 1 Platanus racemosa :: California Sycamore 81 30 Almaden Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774610 5995890.4686 2112526.48313 37.7803585963561 -122.457842053153 (37.7803585963561, -122.457842053153)
88484 110114 Undocumented 2 Platanus racemosa :: California Sycamore 81 463 TEXAS ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6013849.1 2104943.7 37.760553329450005 -122.395183013377 (37.76055332945, -122.395183013377)
91682 112037 Permitted Site 1 Platanus racemosa :: California Sycamore 81 147 Buena Vista Ave East 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2015 12:00:00 AM 3 3x3 Permit Number 775853 6001347.6 2108501.5 37.7696190072387 -122.438674842908 (37.7696190072387, -122.438674842908)
145191 112038 Permitted Site 1 Platanus racemosa :: California Sycamore 81 147 Buena Vista Ave East 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2015 12:00:00 AM 3 3x3 Permit Number 775853 6001347.6 2108501.5 37.7696190072387 -122.438674842908 (37.7696190072387, -122.438674842908)
176353 139293 Undocumented 2 Platanus racemosa :: California Sycamore 81 1499 Post St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   6005109.4757 2114379.0309 37.7859705561221 -122.426081111968 (37.7859705561221, -122.426081111968)
25227 139297 Undocumented 2 Platanus racemosa :: California Sycamore 81 1499 Post St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   6005181.8124 2114392.183 37.7860107566115 -122.42583178305401 (37.7860107566115, -122.425831783054)
180568 139307 Undocumented 2 Platanus racemosa :: California Sycamore 81 1499 Post St 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6005420.8268 2114423.2928 37.7861096804798 -122.425007071523 (37.7861096804798, -122.425007071523)
50408 139315 Undocumented 2 Platanus racemosa :: California Sycamore 81 1302 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 0ft   6005403.9061 2114211.5372 37.7855272963528 -122.42505054055401 (37.7855272963528, -122.425050540554)
40818 139319 Undocumented 2 Platanus racemosa :: California Sycamore 81 1322 Geary Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   6005281.602999999 2114195.139 37.7854753615205 -122.42547250628999 (37.7854753615205, -122.42547250629)
177910 139320 Undocumented 2 Platanus racemosa :: California Sycamore 81 1330 Geary Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   6005252.9062 2114191.0395 37.785462483882604 -122.425571496934 (37.7854624838826, -122.425571496934)
163535 139325 Undocumented 2 Platanus racemosa :: California Sycamore 81 1352 Geary Blvd 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   6005111.8135 2114171.5666 37.7854010428944 -122.426058249419 (37.7854010428944, -122.426058249419)
37628 139326 Undocumented 2 Platanus racemosa :: California Sycamore 81 1360 Geary Blvd 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6005071.5013 2114164.734 37.785380003834206 -122.42619723103901 (37.7853800038342, -122.426197231039)
136837 141158 Undocumented 2 Platanus racemosa :: California Sycamore 81 2013 Geary Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   6001875.9402 2113580.1259 37.7835936815677 -122.437211019524 (37.7835936815677, -122.437211019524)
132923 142617 Undocumented 2 Platanus racemosa :: California Sycamore 81 725 GREENWICH ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   6009365.5599 2120118.4807 37.801969311442704 -122.411761862829 (37.8019693114427, -122.411761862829)
71876 142618 Undocumented 2 Platanus racemosa :: California Sycamore 81 725 GREENWICH ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6009381.7206 2120120.7894 37.8019765571324 -122.41170610218 (37.8019765571324, -122.41170610218)
27027 142619 Undocumented 2 Platanus racemosa :: California Sycamore 81 725 GREENWICH ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   6009396.4961 2120122.6363 37.8019824571048 -122.411655102339 (37.8019824571048, -122.411655102339)
76558 195017 Undocumented 2 Platanus racemosa :: California Sycamore 81 400 Bay Shore Blvd 2 : 4 Tree 1 Private 1     7 Width 3ft   6010318.42243 2097886.76378 37.7409795578731 -122.406896690241 (37.7409795578731, -122.406896690241)
44009 211865 Undocumented 2 Platanus racemosa :: California Sycamore 81 1274 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5993644.4480099995 2106831.85611 37.764593376104706 -122.46519827530199 (37.7645933761047, -122.465198275302)
29744 211866 Undocumented 2 Platanus racemosa :: California Sycamore 81 205 Granada Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   5995618.9525 2091298.42556 37.722056091694796 -122.457245251185 (37.7220560916948, -122.457245251185)
154907 236208 Undocumented 2 Platanus racemosa :: California Sycamore 81 147 Carmel St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5997930.122930001 2105328.91939 37.7607128985969 -122.45026700134501 (37.7607128985969, -122.450267001345)
151006 236209 Undocumented 2 Platanus racemosa :: California Sycamore 81 147 Carmel St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5997968.35291 2105330.47298 37.760719352128795 -122.45013489361 (37.7607193521288, -122.45013489361)
183569 236210 Undocumented 2 Platanus racemosa :: California Sycamore 81 147 Carmel St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5997997.44772 2105333.13475 37.7607283255725 -122.450034460036 (37.7607283255725, -122.450034460036)
119312 236211 Undocumented 2 Platanus racemosa :: California Sycamore 81 332 Highland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6007085.90123 2096525.95828 37.737061678439204 -122.417977144556 (37.7370616784392, -122.417977144556)
184513 236212 Undocumented 2 Platanus racemosa :: California Sycamore 81 1440 Treat Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008697.402919999 2100727.7342 37.748689395406 -122.41270239321001 (37.748689395406, -122.41270239321)
160669 236213 Undocumented 2 Platanus racemosa :: California Sycamore 81 25 Woodland Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997032.77964 2106429.41468 37.763683184847395 -122.453449950272 (37.7636831848474, -122.453449950272)
32515 236214 Undocumented 2 Platanus racemosa :: California Sycamore 81 158 Bocana St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6007313.34504 2098108.2769400002 37.7414191734549 -122.41730286434799 (37.7414191734549, -122.417302864348)
170364 236215 Undocumented 2 Platanus racemosa :: California Sycamore 81 158 Bocana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007320.88948 2098123.5529099996 37.7414615423295 -122.417277860482 (37.7414615423295, -122.417277860482)
163751 236216 Undocumented 2 Platanus racemosa :: California Sycamore 81 156 Bocana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007329.10102 2098137.78644 37.741501086420996 -122.41725047612499 (37.741501086421, -122.417250476125)
30796 236217 Undocumented 2 Platanus racemosa :: California Sycamore 81 328 Highland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007040.37256 2096523.99487 37.7370537248361 -122.418134418894 (37.7370537248361, -122.418134418894)
155557 236218 Undocumented 2 Platanus racemosa :: California Sycamore 81 121 Montcalm St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   6010287.26729 2099820.79013 37.7462882307142 -122.40714070868499 (37.7462882307142, -122.407140708685)
5143 236219 Undocumented 2 Platanus racemosa :: California Sycamore 81 786 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006236.0 2105017.0 37.760328272277 -122.42151850101101 (37.760328272277, -122.421518501011)
170720 236220 Undocumented 2 Platanus racemosa :: California Sycamore 81 780 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006220.52605 2105093.22352 37.7605366917327 -122.421577431964 (37.7605366917327, -122.421577431964)
171552 236221 Undocumented 2 Platanus racemosa :: California Sycamore 81 766 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006214.88989 2105148.6562099997 37.7606885791281 -122.42160086200501 (37.7606885791281, -122.421600862005)
421 236222 DPW Maintained 3 Platanus racemosa :: California Sycamore 81 758 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 3ft   6006212.30332 2105198.62923 37.7608256474983 -122.42161335716801 (37.7608256474983, -122.421613357168)
53353 236223 Undocumented 2 Platanus racemosa :: California Sycamore 81 748 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006211.88041 2105222.0235900003 37.7608898590889 -122.42161648143299 (37.7608898590889, -122.421616481433)
716 236224 DPW Maintained 3 Platanus racemosa :: California Sycamore 81 740 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/1994 12:00:00 AM 7 Width 3ft   6006211.6156 2105275.09716 37.7610355717565 -122.421621166906 (37.7610355717565, -122.421621166906)
65417 236225 Undocumented 2 Platanus racemosa :: California Sycamore 81 720 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6006208.17404 2105371.4094 37.7612998285493 -122.421639910554 (37.7612998285493, -122.421639910554)
151954 236226 Undocumented 2 Platanus racemosa :: California Sycamore 81 686 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006191.11311 2105618.20849 37.7619765189329 -122.42171644736099 (37.7619765189329, -122.421716447361)
150557 236227 Undocumented 2 Platanus racemosa :: California Sycamore 81 620 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006175.69314 2105878.91297 37.762691482659 -122.421788297817 (37.762691482659, -122.421788297817)
33124 236228 Undocumented 2 Platanus racemosa :: California Sycamore 81 584 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006156.95969 2106198.1458400004 37.763566964567794 -122.421875767666 (37.7635669645678, -122.421875767666)
65262 236229 Undocumented 2 Platanus racemosa :: California Sycamore 81 582 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006153.79144 2106219.79715 37.763626235291206 -122.421888263736 (37.7636262352912, -122.421888263736)
71751 236230 Undocumented 2 Platanus racemosa :: California Sycamore 81 580 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006152.8066300005 2106237.8056900003 37.7636756269614 -122.421892949195 (37.7636756269614, -122.421892949195)
29816 236231 Undocumented 2 Platanus racemosa :: California Sycamore 81 560 Valencia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006156.6323 2106292.1424 37.7638250385181 -122.42188357737 (37.7638250385181, -122.42188357737)
155123 236232 Undocumented 2 Platanus racemosa :: California Sycamore 81 560 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006154.39468 2106315.1236900003 37.7638880135333 -122.421892949197 (37.7638880135333, -122.421892949197)
185075 236233 Undocumented 2 Platanus racemosa :: California Sycamore 81 560 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006154.35869 2106335.36124 37.763943579046895 -122.42189451133301 (37.7639435790469, -122.421894511333)
63543 236234 Undocumented 2 Platanus racemosa :: California Sycamore 81 550 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006151.62345 2106356.10426 37.7640003802343 -122.421905445301 (37.7640003802343, -122.421905445301)
23682 236235 Undocumented 2 Platanus racemosa :: California Sycamore 81 550 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006150.31645 2106380.41521 37.7640670586624 -122.42191169288 (37.7640670586624, -122.42191169288)
23429 236236 Undocumented 2 Platanus racemosa :: California Sycamore 81 546 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006147.12053 2106400.7179900003 37.764122625071 -122.421924188966 (37.764122625071, -122.421924188966)
153099 236237 Undocumented 2 Platanus racemosa :: California Sycamore 81 542 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006148.19059 2106430.82622 37.7642053555191 -122.421922626833 (37.7642053555191, -122.421922626833)
23932 236238 Undocumented 2 Platanus racemosa :: California Sycamore 81 540 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006147.07627 2106442.5416200003 37.76423746040079 -122.42192731322201 (37.7642374604008, -122.421927313222)
156292 236239 Undocumented 2 Platanus racemosa :: California Sycamore 81 538 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006143.586130001 2106470.4953400004 37.7643140178894 -122.42194137050501 (37.7643140178894, -122.421941370505)
38081 236240 Undocumented 2 Platanus racemosa :: California Sycamore 81 528 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006144.582330001 2106497.00749 37.76438687018221 -122.42193980837901 (37.7643868701822, -122.421939808379)
5198 236241 Undocumented 2 Platanus racemosa :: California Sycamore 81 522 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6006144.6294599995 2106521.29096 37.76445354951979 -122.421941370498 (37.7644535495198, -122.421941370498)
156799 236242 Undocumented 2 Platanus racemosa :: California Sycamore 81 510 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6006140.292769999 2106573.99555 37.7645980193081 -122.42196011418301 (37.7645980193081, -122.421960114183)
2616 236243 DPW Maintained 3 Platanus racemosa :: California Sycamore 81 504 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/24/2017 02:20:00 PM 3 Width 3ft   6006138.12079 2106622.15868 37.7647301413986 -122.421971048125 (37.7647301413986, -122.421971048125)
150935 236244 Undocumented 2 Platanus racemosa :: California Sycamore 81 515 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006205.617980001 2106566.35806 37.7645807325428 -122.42173362891701 (37.7645807325428, -122.421733628917)
64292 236245 Undocumented 2 Platanus racemosa :: California Sycamore 81 521 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006205.90235 2106536.22169 37.7644980012145 -122.42173050465799 (37.7644980012145, -122.421730504658)
33842 236246 Undocumented 2 Platanus racemosa :: California Sycamore 81 525 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006205.9381 2106515.9841400003 37.764442435690704 -122.421728943463 (37.7644424356907, -122.421728943463)
67515 236247 Undocumented 2 Platanus racemosa :: California Sycamore 81 533 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006207.2084800005 2106489.87514 37.764370818170796 -122.421722694953 (37.7643708181708, -122.421722694953)
36268 236248 Undocumented 2 Platanus racemosa :: California Sycamore 81 3436 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006579.89851 2105554.96639 37.761824787108296 -122.42036729883002 (37.7618247871083, -122.42036729883)
136888 245048 Undocumented 2 Platanus racemosa :: California Sycamore 81 156 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   6000820.7156 2109539.1628 37.772438181941396 -122.440571749918 (37.7724381819414, -122.440571749918)
173139 245049 Undocumented 2 Platanus racemosa :: California Sycamore 81 156 Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6000818.7213 2109552.7904 37.7724754863462 -122.44057962599199 (37.7724754863462, -122.440579625992)

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 65.412ms · Data source: data.sfgov.org