Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, PlantDate
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23983 | 23983 | 224070 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4411 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000003.97958 | 2105733.8947099997 | 37.7619433258348 | -122.443123570319 | (37.7619433258348, -122.443123570319) | |||
27090 | 27090 | 99644 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1795 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | Permit Number 768958 | 5985623.9251 | 2103105.496 | 37.7538960444293 | -122.49266425054701 | (37.7538960444293, -122.492664250547) | ||
27612 | 27612 | 207552 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1353 07th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993922.19207 | 2106326.17113 | 37.7632209099368 | -122.464200926233 | (37.7632209099368, -122.464200926233) | |||
27871 | 27871 | 248510 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 167 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998265.1375 | 2107816.9964 | 37.767563696861004 | -122.449287603561 | (37.767563696861, -122.449287603561) | |||
29324 | 29324 | 246575 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005230.8128 | 2109313.1532400004 | 37.7720677549581 | -122.425300698072 | (37.7720677549581, -122.425300698072) | |||
30573 | 30573 | 224065 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 249 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999809.620019999 | 2105505.92118 | 37.761306282965705 | -122.44377940271099 | (37.7613062829657, -122.443779402711) | |||
31405 | 31405 | 207627 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 335 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5994699.18168 | 2107000.82647 | 37.7651180909611 | -122.461562512304 | (37.7651180909611, -122.461562512304) | |||
33238 | 33238 | 223620 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 439 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006808.42719 | 2101225.05572 | 37.749948725062204 | -122.419269742819 | (37.7499487250622, -122.419269742819) | |||
34326 | 34326 | 223372 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 180 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006460.27427 | 2105075.72628 | 37.760502164064896 | -122.42074700879 | (37.7605021640649, -122.42074700879) | |||
35657 | 35657 | 64564 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1011 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/1988 12:00:00 AM | 11 | Permit Number 25456 | 6009907.55581 | 2117242.96669 | 37.7941042450764 | -122.40968321262699 | (37.7941042450764, -122.409683212627) | |
45044 | 45044 | 126497 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1651 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005046.68269 | 2119164.91299 | 37.7991078310233 | -122.426639284086 | (37.7991078310233, -122.426639284086) | |||
46372 | 46372 | 191683 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1578 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6015394.19835 | 2096650.5888099999 | 37.737867988127704 | -122.38926007030099 | (37.7378679881277, -122.389260070301) | |||
46559 | 46559 | 64158 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 738 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | 11 | 6x6 | Permit Number 24937 | 5991972.51764 | 2110378.72866 | 37.774235580451496 | -122.47123941680901 | (37.7742355804515, -122.471239416809) |
47187 | 47187 | 207659 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1340 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5994898.23943 | 2106428.28078 | 37.7635574848094 | -122.460832527225 | (37.7635574848094, -122.460832527225) | |||
51498 | 51498 | 244489 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1314 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000169.4163 | 2109230.0491 | 37.771552324721206 | -122.442802449862 | (37.7715523247212, -122.442802449862) | |||
52325 | 52325 | 59129 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/1992 12:00:00 AM | 11 | Permit Number 30380 | 5992485.89514 | 2112129.74225 | 37.7790730716469 | -122.46959106216002 | (37.7790730716469, -122.46959106216) | ||
52686 | 52686 | 223596 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 376 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007789.56875 | 2105780.83552 | 37.762513063452104 | -122.416199515798 | (37.7625130634521, -122.416199515798) | |||
58190 | 58190 | 55068 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1408 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 11 | Permit Number 10962 | 6015508.9909 | 2094998.9084 | 37.733339171785204 | -122.38874790280899 | (37.7333391717852, -122.388747902809) | ||
59309 | 59309 | 55067 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1404 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 11 | Permit Number 10961 | 6015524.9297 | 2095021.4425 | 37.7334019292539 | -122.388694369981 | (37.7334019292539, -122.388694369981) | ||
59407 | 59407 | 191111 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2251 24th St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6011810.68033 | 2102303.0748 | 37.7531891829555 | -122.402047375812 | (37.7531891829555, -122.402047375812) | |||
62329 | 62329 | 223571 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 400 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007463.60834 | 2095702.7680000002 | 37.734822629158394 | -122.416612940446 | (37.7348226291584, -122.416612940446) | |||
63068 | 63068 | 224087 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 216 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004639.34009 | 2109155.86974 | 37.771602459215295 | -122.427335443897 | (37.7716024592153, -122.427335443897) | |||
63581 | 63581 | 207556 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1333 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5993304.33349 | 2106388.43984 | 37.763356252508295 | -122.46634240178999 | (37.7633562525083, -122.46634240179) | |||
69071 | 69071 | 67317 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 715 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 11 | Permit Number 30798 | 5992850.6413199995 | 2110569.51812 | 37.7748101916189 | -122.468215736984 | (37.7748101916189, -122.468215736984) | |
71263 | 71263 | 72055 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2161 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1990 12:00:00 AM | 11 | 6008082.6141 | 2119894.2799400003 | 37.8012816578905 | -122.41618558619301 | (37.8012816578905, -122.416185586193) | ||
74605 | 74605 | 217746 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 631 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 5996538.5455 | 2107286.52393 | 37.7660082444099 | -122.455221286434 | (37.7660082444099, -122.455221286434) | |||
74809 | 74809 | 223627 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 326 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006741.07973 | 2101721.27306 | 37.751307431593794 | -122.419537835196 | (37.7513074315938, -122.419537835196) | |||
93213 | 93213 | 126532 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1101 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009864.00363 | 2117536.67962 | 37.7949082686427 | -122.409854651267 | (37.7949082686427, -122.409854651267) | |||
123825 | 123825 | 223535 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4124 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6003065.646000001 | 2100682.11762 | 37.7482464442341 | -122.43217368948099 | (37.7482464442341, -122.432173689481) | |||
129981 | 129981 | 223633 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006707.78219 | 2102302.55947 | 37.752901635514704 | -122.419694221906 | (37.7529016355147, -122.419694221906) | |||
130571 | 130571 | 223609 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3330 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006825.79297 | 2102649.13813 | 37.7538599081198 | -122.41931070154699 | (37.7538599081198, -122.419310701547) | |||
132491 | 132491 | 207683 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2430 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5990785.45213 | 2098828.98971 | 37.7424543273065 | -122.474502592844 | (37.7424543273065, -122.474502592844) | |||
135696 | 135696 | 223477 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 181 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006251.94836 | 2095849.2392099998 | 37.7351565869995 | -122.420812471312 | (37.7351565869995, -122.420812471312) | |||
135769 | 135769 | 223434 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 335 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006140.81563 | 2107660.72515 | 37.7675819509849 | -122.422035512441 | (37.7675819509849, -122.422035512441) | |||
135934 | 135934 | 223566 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 144 Nevada St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6009026.08799 | 2097793.63743 | 37.7406514546128 | -122.41135854797301 | (37.7406514546128, -122.411358547973) | |||
136898 | 136898 | 207551 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1353 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993920.840969999 | 2106341.12127 | 37.7632618812439 | -122.46420668461501 | (37.7632618812439, -122.464206684615) | |||
137053 | 137053 | 189250 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1301 Bay Shore Blvd | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6011646.806480001 | 2093004.20248 | 37.7276473117623 | -122.40196044913799 | (37.7276473117623, -122.401960449138) | |||
138180 | 138180 | 246490 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399 Duncan St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6004063.56102 | 2099816.02709 | 37.7459248893202 | -122.428661198349 | (37.7459248893202, -122.428661198349) | |||
147173 | 147173 | 207554 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1353 07th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993924.42937 | 2106289.97984 | 37.76312166705421 | -122.46419056066999 | (37.7631216670542, -122.46419056067) | |||
149468 | 149468 | 64970 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1651 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | 11 | Permit Number 26005 | 6005030.07255 | 2119163.06773 | 37.7991018253479 | -122.426696629358 | (37.7991018253479, -122.426696629358) | |
149517 | 149517 | 224076 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4347 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000486.58974 | 2105759.50632 | 37.7620411550071 | -122.441456253314 | (37.7620411550071, -122.441456253314) | |||
149899 | 149899 | 61985 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3212 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1985 12:00:00 AM | 11 | Permit Number 22052 | 6004200.44828 | 2120220.07156 | 37.8019571458696 | -122.429642837148 | (37.8019571458696, -122.429642837148) | |
151117 | 151117 | 189247 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1645 Bay Shore Blvd | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012112.47662 | 2091125.23091 | 37.7225140193029 | -122.40021870064699 | (37.7225140193029, -122.400218700647) | |||
151155 | 151155 | 223605 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 28 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007673.38803 | 2107757.3509 | 37.767933580499 | -122.416741374417 | (37.767933580499, -122.416741374417) | |||
153841 | 153841 | 200708 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1399 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6015645.8444 | 2095108.8309 | 37.7336485807976 | -122.388282427214 | (37.7336485807976, -122.388282427214) | |||
155538 | 155538 | 223421 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 390 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008952.933119999 | 2100044.20603 | 37.74682691743671 | -122.41177047704201 | (37.7468269174367, -122.411770477042) | |||
158577 | 158577 | 207550 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1353 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993920.73068 | 2106351.7347 | 37.7632910165944 | -122.46420783662799 | (37.7632910165944, -122.464207836628) | |||
159081 | 159081 | 223505 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006512.313019999 | 2102586.69757 | 37.753670800474 | -122.420390358348 | (37.753670800474, -122.420390358348) | |||
160036 | 160036 | 246576 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 5 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005228.37861 | 2109333.02061 | 37.7721221684335 | -122.42531053216001 | (37.7721221684335, -122.42531053216) | |||
160431 | 160431 | 223474 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 261 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006757.06634 | 2095805.9184299998 | 37.7350660954209 | -122.419063020159 | (37.7350660954209, -122.419063020159) | |||
161955 | 161955 | 223603 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 66 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007689.4598 | 2107580.51877 | 37.767448944844396 | -122.416673255272 | (37.7674489448444, -122.416673255272) | |||
164021 | 164021 | 223435 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 335 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006142.1002 | 2107638.15055 | 37.76752003894389 | -122.422029465401 | (37.7675200389439, -122.422029465401) | |||
164172 | 164172 | 62981 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1317 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | 11 | Permit Number 23371 | 6007225.76848 | 2118431.56402 | 37.797217191673205 | -122.41904684764299 | (37.7972171916732, -122.419046847643) | |
165576 | 165576 | 66089 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2240 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/08/1990 12:00:00 AM | 11 | Permit Number 29133 | 6007618.971469999 | 2120081.10266 | 37.8017685454413 | -122.41780324801701 | (37.8017685454413, -122.417803248017) | |
166519 | 166519 | 189246 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2445 Mariposa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010268.3628 | 2105949.94091 | 37.763116456370796 | -122.407638156081 | (37.7631164563708, -122.407638156081) | |||
169187 | 169187 | 58274 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 679 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 11 | Permit Number 28518 | 6002069.6967400005 | 2089980.14992 | 37.718804779905206 | -122.43485242630301 | (37.7188047799052, -122.434852426303) | |
169630 | 169630 | 223569 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 500 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007635.55401 | 2095689.61237 | 37.734796175602604 | -122.416017531695 | (37.7347961756026, -122.416017531695) | |||
171714 | 171714 | 224088 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 222 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004610.983630001 | 2109155.17088 | 37.771598936562796 | -122.427433480775 | (37.7715989365628, -122.427433480775) | |||
178243 | 178243 | 223625 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 440 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006766.26439 | 2101216.80639 | 37.749923699622606 | -122.419414959037 | (37.7499236996226, -122.419414959037) | |||
181272 | 181272 | 207690 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 642 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5991148.86446 | 2099110.57767 | 37.743248544694204 | -122.473266566413 | (37.7432485446942, -122.473266566413) | |||
181330 | 181330 | 31671 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1435 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/2003 12:00:00 AM | 11 | Permit Number 35179 | 6007129.43317 | 2116257.26195 | 37.79124167420971 | -122.419225877479 | (37.7912416742097, -122.419225877479) | |
181659 | 181659 | 207634 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1377 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5994548.5579699995 | 2106167.4368 | 37.762821148712504 | -122.46202303893499 | (37.7628211487125, -122.462023038935) | |||
181830 | 181830 | 207662 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1203 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5996707.43605 | 2107271.27987 | 37.7659760765509 | -122.45463603013799 | (37.7659760765509, -122.454636030138) | |||
181972 | 181972 | 224050 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3864 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002642.02171 | 2103582.88147 | 37.7561872258806 | -122.433845873598 | (37.7561872258806, -122.433845873598) | |||
186042 | 186042 | 72426 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4250X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 11 | 3x3 | Permit Number 773790 | 5990138.03134 | 2109951.66223 | 37.772956689267204 | -122.47755394624 | (37.7729566892672, -122.47755394624) |
186882 | 186882 | 61980 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3105 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1985 12:00:00 AM | 11 | Permit Number 22047 | 6004204.10885 | 2119849.9786 | 37.8009411736685 | -122.42960375979999 | (37.8009411736685, -122.4296037598) |
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");