Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5920 | 5920 | 139500 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 748 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 5999620.0523 | 2111133.4316 | 37.776747194618395 | -122.44483956661199 | (37.7767471946184, -122.444839566612) | ||||
24187 | 24187 | 142264 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 575 LINDEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004642.0376 | 2110688.0426 | 37.775809585078896 | -122.427435282317 | (37.7758095850789, -122.427435282317) | |||
24822 | 24822 | 250192 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011786.88966 | 2119947.0785 | 37.8016342173021 | -122.403370805543 | (37.8016342173021, -122.403370805543) | |||
25501 | 25501 | 141630 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1801 GROVE ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999025.3732 | 2110414.9246 | 37.774740403045996 | -122.446845016858 | (37.774740403046, -122.446845016858) | |||
31678 | 31678 | 137728 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1989 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999638.3271 | 2111189.9480000003 | 37.77690341710429 | -122.444780412241 | (37.7769034171043, -122.444780412241) | |||
33547 | 33547 | 137666 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1901 GOLDEN GATE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000398.0082 | 2111639.7629 | 37.7781818179135 | -122.442184748811 | (37.7781818179135, -122.442184748811) | |||
33826 | 33826 | 184961 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1990 41st Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5983548.8239 | 2101628.2630000003 | 37.7497184185455 | -122.4997311455 | (37.7497184185455, -122.4997311455) | |||
35471 | 35471 | 140101 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 771 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999584.517999999 | 2111094.1746 | 37.7766373769699 | -122.44495966716002 | (37.7766373769699, -122.44495966716) | |||
37452 | 37452 | 140100 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 785 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999576.3959 | 2111131.7395 | 37.7767400570235 | -122.44499046488501 | (37.7767400570235, -122.444990464885) | |||
38437 | 38437 | 142346 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 505 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999691.4094 | 2110243.208 | 37.7743069396367 | -122.44452872557699 | (37.7743069396367, -122.444528725577) | |||
41788 | 41788 | 138778 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6001713.8653 | 2114306.3395 | 37.785578464198 | -122.437823766308 | (37.785578464198, -122.437823766308) | |||
41964 | 41964 | 246075 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 635 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998492.5621 | 2108432.0423 | 37.7692654626532 | -122.44854527514299 | (37.7692654626532, -122.448545275143) | |||
42359 | 42359 | 138339 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001909.1348 | 2114331.7204 | 37.7856592553419 | -122.437150009777 | (37.7856592553419, -122.437150009777) | |||
42577 | 42577 | 139655 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 848 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000491.15 | 2111934.8144 | 37.7789972619427 | -122.441883720544 | (37.7789972619427, -122.441883720544) | |||
45099 | 45099 | 184964 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1990 41st Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5983545.7781 | 2101731.1432 | 37.7500007203614 | -122.499749280915 | (37.7500007203614, -122.499749280915) | |||
45153 | 45153 | 140717 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 556 SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002162.097 | 2110427.6982 | 37.774954171002 | -122.43599537996201 | (37.774954171002, -122.435995379962) | |||
45939 | 45939 | 138342 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001808.8392 | 2114319.4393 | 37.7856198329437 | -122.437496123305 | (37.7856198329437, -122.437496123305) | |||
47761 | 47761 | 250191 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 0ft | 6011795.08799 | 2119945.2148 | 37.8016295579248 | -122.40334230423099 | (37.8016295579248, -122.403342304231) | |||
50765 | 50765 | 244169 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1752 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998187.9203 | 2108956.9743 | 37.7706893684237 | -122.449636842472 | (37.7706893684237, -122.449636842472) | |||
54226 | 54226 | 137665 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1901 GOLDEN GATE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000382.7272 | 2111637.7254 | 37.778175352566 | -122.44223746490101 | (37.778175352566, -122.442237464901) | |||
55440 | 55440 | 138357 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001830.9567 | 2114618.7351 | 37.7864428800724 | -122.437441043234 | (37.7864428800724, -122.437441043234) | |||
60228 | 60228 | 245868 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 415 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005026.3603 | 2110433.2652 | 37.775131757595204 | -122.42608767011801 | (37.7751317575952, -122.426087670118) | |||
60547 | 60547 | 184904 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1990 41st Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983548.4855 | 2101753.1406 | 37.7500612779998 | -122.499741544392 | (37.7500612779998, -122.499741544392) | |||
60577 | 60577 | 245840 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 421 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005021.78 | 2110481.0306 | 37.775262650872 | -122.42610691556601 | (37.775262650872, -122.426106915566) | |||
61827 | 61827 | 138346 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1770 SCOTT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001590.3534 | 2114514.4235 | 37.7861427855089 | -122.438265993007 | (37.7861427855089, -122.438265993007) | |||
61990 | 61990 | 140718 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 556 SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002160.0013 | 2110449.3533 | 37.7750135114472 | -122.436004179308 | (37.7750135114472, -122.436004179308) | |||
62430 | 62430 | 246034 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 618 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998524.9649 | 2108501.9958 | 37.7694593898353 | -122.44843823441002 | (37.7694593898353, -122.44843823441) | |||
63850 | 63850 | 138348 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001613.9728 | 2114589.4995 | 37.786350268304 | -122.43818965646001 | (37.786350268304, -122.43818965646) | |||
64130 | 64130 | 248395 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1655 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997659.0251 | 2108142.2349 | 37.768422030688896 | -122.451407517669 | (37.7684220306889, -122.451407517669) | |||
65413 | 65413 | 137613 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1502 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001914.7987 | 2111556.8609 | 37.778040516588604 | -122.436931690487 | (37.7780405165886, -122.436931690487) | |||
65658 | 65658 | 183506 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2542 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5988021.6131 | 2097993.9577 | 37.7400010259161 | -122.483997786352 | (37.7400010259161, -122.483997786352) | |||
69574 | 69574 | 245838 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 423 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6005012.6195 | 2110528.7961 | 37.7753932855436 | -122.426142005084 | (37.7753932855436, -122.426142005084) | |||
70197 | 70197 | 138347 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1770 SCOTT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6001586.1357 | 2114554.9139 | 37.786253721877706 | -122.438283486898 | (37.7862537218777, -122.438283486898) | |||
70529 | 70529 | 138351 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001690.7359 | 2114600.4656 | 37.786384743909295 | -122.437924862001 | (37.7863847439093, -122.437924862001) | |||
70721 | 70721 | 245867 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 419 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005023.743 | 2110457.4751 | 37.775198084155605 | -122.42609844781799 | (37.7751980841556, -122.426098447818) | |||
72487 | 72487 | 249768 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 266 Lombard St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6010977.12206 | 2120702.10235 | 37.8036620671076 | -122.406226211476 | (37.8036620671076, -122.406226211476) | |||
73916 | 73916 | 200693 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1607 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6015092.9345 | 2095762.8694 | 37.7354137854933 | -122.39023969268999 | (37.7354137854933, -122.39023969269) | |||
74240 | 74240 | 141691 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5996753.535 | 2112367.4021 | 37.7799713474759 | -122.45484482437 | (37.7799713474759, -122.45484482437) | |||
75193 | 75193 | 139501 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 750 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999619.0371 | 2111147.3069 | 37.7767852347068 | -122.444844076108 | (37.7767852347068, -122.444844076108) | |||
75611 | 75611 | 182146 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1690 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5989681.6149 | 2103872.2722 | 37.756237834999 | -122.478688039412 | (37.756237834999, -122.478688039412) | |||
132605 | 132605 | 142261 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 575 LINDEN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004683.1776 | 2110693.6136 | 37.775827208405104 | -122.427293365492 | (37.7758272084051, -122.427293365492) | |||
134727 | 134727 | 140102 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1720 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999455.5793 | 2110868.7857 | 37.7760111570338 | -122.445389492297 | (37.7760111570338, -122.445389492297) | |||
135843 | 135843 | 250193 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | Width 0ft | 6011782.399230001 | 2119949.71509 | 37.8016412059365 | -122.403386530161 | (37.8016412059365, -122.403386530161) | |||
149751 | 149751 | 138140 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1942 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999833.7647 | 2111267.0068 | 37.7771261520231 | -122.444109874692 | (37.7771261520231, -122.444109874692) | |||
150574 | 150574 | 138352 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001715.4366 | 2114603.3734 | 37.78639413258121 | -122.437839612353 | (37.7863941325812, -122.437839612353) | |||
154005 | 154005 | 248396 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1655 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997671.1383 | 2108143.749 | 37.768426881635605 | -122.45136572862499 | (37.7684268816356, -122.451365728625) | |||
156262 | 156262 | 140103 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1720 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999438.9967 | 2110868.4473 | 37.776009281241 | -122.44544683133002 | (37.776009281241, -122.44544683133) | |||
157543 | 157543 | 139098 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2600 POST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999639.9141 | 2113670.3506 | 37.7837140544374 | -122.44495327295601 | (37.7837140544374, -122.444953272956) | |||
157995 | 157995 | 140719 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 556 SCOTT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002157.9056 | 2110466.8172 | 37.775061343901896 | -122.436012678697 | (37.7750613439019, -122.436012678697) | |||
158299 | 158299 | 138337 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001955.802999999 | 2114338.6797 | 37.7856810164636 | -122.436989049911 | (37.7856810164636, -122.436989049911) | |||
159913 | 159913 | 138338 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001931.2408 | 2114335.4048 | 37.7856706283151 | -122.437073793387 | (37.7856706283151, -122.437073793387) | |||
164961 | 164961 | 138533 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2299 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001645.5525 | 2114240.3384 | 37.7853933573613 | -122.438055378776 | (37.7853933573613, -122.438055378776) | |||
170339 | 170339 | 140104 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1750 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999428.844 | 2110866.7552 | 37.776004055577204 | -122.44548183036301 | (37.7760040555772, -122.445481830363) | |||
172105 | 172105 | 182147 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1690 21st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5989680.1915 | 2103890.3009 | 37.756287254354 | -122.478694280415 | (37.756287254354, -122.478694280415) | |||
173572 | 173572 | 245839 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 423 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005015.8911 | 2110507.8578 | 37.775335978986796 | -122.4261291969 | (37.7753359789868, -122.4261291969) | |||
174353 | 174353 | 138350 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6001659.5245 | 2114595.4043 | 37.786369071961104 | -122.438032482637 | (37.7863690719611, -122.438032482637) | |||
175294 | 175294 | 141632 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1801 GROVE ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999054.1432 | 2110418.5587 | 37.7747520248793 | -122.446745757486 | (37.7747520248793, -122.446745757486) | |||
179698 | 179698 | 218406 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 225 Castenada Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5994236.919980001 | 2100511.7669599997 | 37.7472741826649 | -122.462690582315 | (37.7472741826649, -122.462690582315) | |||
180907 | 180907 | 137667 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1901 GOLDEN GATE AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000415.6663 | 2111642.14 | 37.7781893511619 | -122.442123833863 | (37.7781893511619, -122.442123833863) | |||
184019 | 184019 | 245165 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1364 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000037.7937 | 2109212.4329 | 37.7714964504984 | -122.443256472847 | (37.7714964504984, -122.443256472847) | |||
187109 | 187109 | 142298 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1501 GROVE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000546.8174 | 2110627.5355 | 37.775410978082 | -122.44159730622299 | (37.775410978082, -122.441597306223) | |||
187692 | 187692 | 138344 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001758.896000001 | 2114311.2519 | 37.785594512870205 | -122.43766832543301 | (37.7855945128702, -122.437668325433) | |||
188012 | 188012 | 138353 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001742.4732 | 2114607.6747 | 37.786407480206705 | -122.43774638091499 | (37.7864074802067, -122.437746380915) |
JSON shape: default, array, newline-delimited
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");