Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3441 | 3441 | 32703 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 890 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37106 | 6007477.85623 | 2114415.95786 | 37.7862055211206 | -122.417889760126 | (37.7862055211206, -122.417889760126) |
30304 | 30304 | 125706 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 68 Pleasant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008674.29968 | 2116820.86226 | 37.7928760643434 | -122.41392055009199 | (37.7928760643434, -122.413920550092) | |||
30971 | 30971 | 188230 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 123 Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012869.68369 | 2113682.0678 | 37.784492396237 | -122.39918379321001 | (37.784492396237, -122.39918379321) | |||
32233 | 32233 | 204292 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 128 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 5993577.25837 | 2103274.10161 | 37.7548208328355 | -122.465172231806 | (37.7548208328355, -122.465172231806) | |||
33243 | 33243 | 204317 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 120 Merced Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5994559.82289 | 2099500.03958 | 37.7445148251981 | -122.461500679435 | (37.7445148251981, -122.461500679435) | |||
36747 | 36747 | 188229 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 602 Arthur Ave | 49 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6015937.59243 | 2099752.45795 | 37.746415195218205 | -122.387597621357 | (37.7464151952182, -122.387597621357) | ||||
38063 | 38063 | 185803 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2614 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5986857.6825 | 2101684.1029 | 37.750065347280895 | -122.488293237257 | (37.7500653472809, -122.488293237257) | |||
44672 | 44672 | 205606 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 549 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998487.62323 | 2094969.3893900001 | 37.7323000389202 | -122.44759312714599 | (37.7323000389202, -122.447593127146) | |||
47364 | 47364 | 204278 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1765 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993091.39262 | 2103476.13985 | 37.7553475477697 | -122.466867162505 | (37.7553475477697, -122.466867162505) | |||
50049 | 50049 | 72364 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 617 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 8 | 5991265.11371 | 2111180.08401 | 37.7763949395058 | -122.47374490167499 | (37.7763949395058, -122.473744901675) | ||
53433 | 53433 | 125701 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1170 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009113.9445 | 2117050.28629 | 37.7935306880345 | -122.412415576041 | (37.7935306880345, -122.412415576041) | |||
55600 | 55600 | 205571 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 114 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993972.11 | 2097104.0492 | 37.7379021902407 | -122.463359020507 | (37.7379021902407, -122.463359020507) | |||
55729 | 55729 | 221138 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 110 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003494.94443 | 2095122.0497700002 | 37.733004107356294 | -122.430292564064 | (37.7330041073563, -122.430292564064) | |||
57442 | 57442 | 221174 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1200 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002497.99199 | 2102014.4417 | 37.751872490040896 | -122.43423185273899 | (37.7518724900409, -122.434231852739) | |||
61970 | 61970 | 221157 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 337 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008639.65317 | 2097144.46538 | 37.738847288673 | -122.412648816096 | (37.738847288673, -122.412648816096) | |||
62538 | 62538 | 221144 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3931 21st St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6002271.182569999 | 2103525.3930099998 | 37.7560083255284 | -122.43512424821199 | (37.7560083255284, -122.435124248212) | ||||
62915 | 62915 | 221114 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 424 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008042.92027 | 2096868.3927 | 37.7380557440706 | -122.414692514653 | (37.7380557440706, -122.414692514653) | |||
65610 | 65610 | 221154 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 445 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008062.65586 | 2096770.15245 | 37.737787106693396 | -122.41461732863998 | (37.7377871066934, -122.41461732864) | |||
68030 | 68030 | 204277 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1765 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993090.13896 | 2103495.6266 | 37.7554009809821 | -122.466872914554 | (37.7554009809821, -122.466872914554) | |||
68629 | 68629 | 205598 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 600x Laguna Honda Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 5995474.65556 | 2099916.18224 | 37.745710062887 | -122.458367509749 | (37.745710062887, -122.458367509749) | |||
69853 | 69853 | 204260 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1541 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992419.35568 | 2104946.71184 | 37.7593465442125 | -122.46929828000499 | (37.7593465442125, -122.469298280005) | |||
72316 | 72316 | 175551 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 410 Italy Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001714.08055 | 2089236.3629599998 | 37.716742309774496 | -122.436028453575 | (37.7167423097745, -122.436028453575) | |||
73722 | 73722 | 34655 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2020 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38333 | 5988552.6311 | 2105140.1389 | 37.7596534386529 | -122.48268531251499 | (37.7596534386529, -122.482685312515) | |
74504 | 74504 | 205584 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 40 Maywood Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994325.75965 | 2096193.23667 | 37.735421692758 | -122.462070256959 | (37.735421692758, -122.462070256959) | |||
84049 | 84049 | 107009 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
90063 | 90063 | 107007 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
96501 | 96501 | 69421 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 400 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1994 12:00:00 AM | 8 | Permit Number 33526 | 6008905.76984219 | 2106354.06627794 | 37.7641497228891 | -122.41237948925101 | (37.7641497228891, -122.412379489251) | ||
96908 | 96908 | 113825 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1599x CASTRO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/10/2015 12:00:00 AM | 8 | 3x3 | 6002577.0 | 2101074.0 | 37.749294743689795 | -122.433891418078 | (37.7492947436898, -122.433891418078) | |
97462 | 97462 | 47590 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 246 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45434 | 5987870.09368443 | 2115354.49759594 | 37.7876594816311 | -122.485795537984 | (37.7876594816311, -122.485795537984) | |
98482 | 98482 | 107003 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
100357 | 100357 | 66425 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 337 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | 8 | 3x3 | Permit Number 29566 | 6008654.10344933 | 2097170.34560865 | 37.7389191611384 | -122.41260068259399 | (37.7389191611384, -122.412600682594) |
113605 | 113605 | 107006 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
118818 | 118818 | 107004 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
123167 | 123167 | 113824 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1599x CASTRO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002577.0 | 2101074.0 | 37.749294743689795 | -122.433891418078 | (37.7492947436898, -122.433891418078) | |||
128964 | 128964 | 34704 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 615 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38361 | 5981612.97325 | 2111540.52057 | 37.7768208414608 | -122.50716052883699 | (37.7768208414608, -122.507160528837) | |
129747 | 129747 | 33247 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2586 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 8 | Permit Number 37428 | 5987412.9749 | 2097696.9936 | 37.7391501881737 | -122.486080385609 | (37.7391501881737, -122.486080385609) | |
133304 | 133304 | 125713 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 956 Vallejo St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6008845.05182 | 2118706.6905799997 | 37.7980636731514 | -122.41346316930799 | (37.7980636731514, -122.413463169308) | ||||
135069 | 135069 | 71610 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 265 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 8 | 5994208.54554 | 2086740.2113599998 | 37.7094592149285 | -122.46179029709499 | (37.7094592149285, -122.461790297095) | ||
137249 | 137249 | 31161 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 401 Ramsell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34862 | 5992970.452219999 | 2089928.9593099998 | 37.7181434013758 | -122.466300907981 | (37.7181434013758, -122.466300907981) | |
141121 | 141121 | 111212 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3100x 19TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008781.0 | 2105093.0 | 37.7606801217813 | -122.412721875792 | (37.7606801217813, -122.412721875792) | |||
152775 | 152775 | 221112 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008049.49369 | 2096950.1796799998 | 37.738280682507 | -122.41467557324499 | (37.738280682507, -122.414675573245) | |||
153663 | 153663 | 33178 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3333 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 8 | Permit Number 37390 | 5985663.1141 | 2098179.7448 | 37.74037355789021 | -122.49216606308599 | (37.7403735578902, -122.492166063086) | |
158003 | 158003 | 221169 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 217 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003687.36586 | 2101552.84441 | 37.75067248686889 | -122.430085907055 | (37.7506724868689, -122.430085907055) | |||
158263 | 158263 | 204332 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 351 Kenwood Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993583.80688 | 2093600.7249900002 | 37.7282605495865 | -122.464447270321 | (37.7282605495865, -122.464447270321) | |||
158553 | 158553 | 47683 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 730 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | 8 | Permit Number 45474 | 5991337.42645 | 2110428.10245 | 37.7743343910633 | -122.473439892203 | (37.7743343910633, -122.473439892203) | |
159373 | 159373 | 38691 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 13904 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 8 | Permit Number 40604 | 6001240.455 | 2110421.1619 | 37.7748838228637 | -122.439183061176 | (37.7748838228637, -122.439183061176) | |
160322 | 160322 | 33239 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2581 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1996 12:00:00 AM | 8 | Permit Number 37424 | 5988605.1751 | 2097786.0324 | 37.739464073986 | -122.481964866217 | (37.739464073986, -122.481964866217) | |
162405 | 162405 | 33264 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1424 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 8 | Permit Number 37439 | 5988466.7481 | 2097653.8327 | 37.7390930364544 | -122.48243379651501 | (37.7390930364544, -122.482433796515) | |
163553 | 163553 | 34707 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 678 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38364 | 5981677.4444 | 2111118.32695 | 37.7756654188698 | -122.506906183465 | (37.7756654188698, -122.506906183465) | |
166307 | 166307 | 175553 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 410 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001661.33875 | 2089268.82238 | 37.716828439656794 | -122.43621307719299 | (37.7168284396568, -122.436213077193) | |||
168248 | 168248 | 221136 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 30 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005927.372280001 | 2103475.84509 | 37.7560792137102 | -122.42247639157301 | (37.7560792137102, -122.422476391573) | |||
170976 | 170976 | 204295 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2241 15th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991723.82776 | 2100147.7502900003 | 37.7461296298746 | -122.471354067261 | (37.7461296298746, -122.471354067261) | |||
171032 | 171032 | 204272 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 347 Parnassus Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5996361.7812 | 2106543.3975299997 | 37.763957666938 | -122.455778951549 | (37.763957666938, -122.455778951549) | |||
172493 | 172493 | 221117 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 456 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008030.10895 | 2096733.8302799999 | 37.7376855453496 | -122.414727289648 | (37.7376855453496, -122.414727289648) | |||
173685 | 173685 | 221102 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 5 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6009385.9447800005 | 2105435.68423 | 37.7616549897172 | -122.41065383649901 | (37.7616549897172, -122.410653836499) | |||
178092 | 178092 | 204291 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5992458.815230001 | 2103838.74555 | 37.7563066387524 | -122.46908117467501 | (37.7563066387524, -122.469081174675) | |||
181814 | 181814 | 74235 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1069 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 8 | 6008785.22187 | 2115933.15302 | 37.79044486048821 | -122.413473942277 | (37.7904448604882, -122.413473942277) | ||
183994 | 183994 | 204276 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1739 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993085.208980001 | 2103636.9214 | 37.7557886553491 | -122.466900235077 | (37.7557886553491, -122.466900235077) | |||
184672 | 184672 | 205591 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 64 Linares Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994060.21953 | 2102134.15413 | 37.7517186672821 | -122.463419311054 | (37.7517186672821, -122.463419311054) | |||
188738 | 188738 | 204257 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1419 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5994248.63466 | 2105844.7666700003 | 37.76191790830379 | -122.463036948099 | (37.7619179083038, -122.463036948099) |
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");