Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 89786 | 89786 | 6508 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2004 12:00:00 AM | 3 | 3X3 | 6016839.72201 | 2097711.4040099997 | 37.7408608044909 | -122.38433600211599 | (37.7408608044909, -122.384336002116) | ||
| 84767 | 84767 | 6507 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2004 12:00:00 AM | 3 | 3X3 | 6016854.03501 | 2097699.47601 | 37.740828844031604 | -122.38428568209999 | (37.7408288440316, -122.3842856821) | ||
| 143134 | 143134 | 6506 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 48 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2004 12:00:00 AM | 3 | 3x3 | 6016870.73401 | 2097688.74101 | 37.7408002912118 | -122.38422719521799 | (37.7408002912118, -122.384227195218) | ||
| 72587 | 72587 | 6505 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2004 12:00:00 AM | 3 | 3x3 | 6016887.43301 | 2097676.8130099997 | 37.7407684626261 | -122.38416862532 | (37.7407684626261, -122.38416862532) | ||
| 88688 | 88688 | 6504 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 46 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2004 12:00:00 AM | 3 | 3X3 | 6016904.13201 | 2097662.49901 | 37.7407300825378 | -122.38410988935699 | (37.7407300825378, -122.384109889357) | ||
| 95212 | 95212 | 6501 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2014 12:00:00 AM | 3 | 3x3 | 6016955.42201 | 2097623.1370099997 | 37.740624838003896 | -122.383929806075 | (37.7406248380039, -122.383929806075) | ||
| 102807 | 102807 | 6499 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6017004.32701 | 2097592.12501 | 37.7405423887708 | -122.38375855101201 | (37.7405423887708, -122.383758551012) | ||
| 182036 | 182036 | 190437 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 41 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017375.251180001 | 2097308.04531 | 37.73978285968779 | -122.382456265548 | (37.7397828596878, -122.382456265548) | |||
| 172991 | 172991 | 190436 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 40 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017392.19785 | 2097295.20205 | 37.7397485307771 | -122.38239677720199 | (37.7397485307771, -122.382396777202) | |||
| 55193 | 55193 | 190435 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 35 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017477.19545 | 2097232.60183 | 37.7395813377956 | -122.38209853501499 | (37.7395813377956, -122.382098535015) | |||
| 32001 | 32001 | 190434 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 33 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017509.45239 | 2097206.48557 | 37.739511409230104 | -122.381985187163 | (37.7395114092301, -122.381985187163) | |||
| 91604 | 91604 | 21229 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2392X Sunset Blvd | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 158224 | 158224 | 190433 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 32 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017527.816819999 | 2097194.77168 | 37.739480259397205 | -122.381920875742 | (37.7394802593972, -122.381920875742) | |||
| 92817 | 92817 | 48369 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.76541008749211 | -122.402712708416 | (37.7654100874921, -122.402712708416) | |||
| 181258 | 181258 | 190432 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 31 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017540.84506 | 2097183.62792 | 37.739450380318395 | -122.38187505441499 | (37.7394503803184, -122.381875054415) | |||
| 98702 | 98702 | 48368 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.76541008749211 | -122.402712708416 | (37.7654100874921, -122.402712708416) | |||
| 112355 | 112355 | 21227 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2392X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 111230 | 111230 | 21226 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2392X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 125276 | 125276 | 48366 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.76541008749211 | -122.402712708416 | (37.7654100874921, -122.402712708416) | |||
| 169860 | 169860 | 190431 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 29 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017575.221969999 | 2097158.85814 | 37.7393842657625 | -122.381754470602 | (37.7393842657625, -122.381754470602) | |||
| 116222 | 116222 | 48365 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.76541008749211 | -122.402712708416 | (37.7654100874921, -122.402712708416) | |||
| 172543 | 172543 | 190430 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 28 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017590.10949 | 2097147.67735 | 37.7393543876054 | -122.381702218193 | (37.7393543876054, -122.381702218193) | |||
| 29108 | 29108 | 190519 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 299 Bryant St | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6015412.9478400005 | 2114035.0221599997 | 37.785602934875 | -122.39040956394501 | (37.785602934875, -122.390409563945) | |||
| 39849 | 39849 | 190429 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 27 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017626.76379 | 2097120.54655 | 37.7392819157251 | -122.381573596257 | (37.7392819157251, -122.381573596257) | |||
| 121391 | 121391 | 48364 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.76541008749211 | -122.402712708416 | (37.7654100874921, -122.402712708416) | |||
| 61401 | 61401 | 190428 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 26 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017641.63274 | 2097108.43991 | 37.7392494942632 | -122.38152134383101 | (37.7392494942632, -122.381521343831) | |||
| 111029 | 111029 | 48363 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.76541008749211 | -122.402712708416 | (37.7654100874921, -122.402712708416) | |||
| 124573 | 124573 | 6444 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1100X Evans Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | ||
| 55951 | 55951 | 190427 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 25 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017659.5138 | 2097095.8095900002 | 37.7392158011555 | -122.38145864041401 | (37.7392158011555, -122.381458640414) | |||
| 120628 | 120628 | 48362 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.76541008749211 | -122.402712708416 | (37.7654100874921, -122.402712708416) | |||
| 168686 | 168686 | 190518 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 299 Bryant St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6015402.02385 | 2114023.64667 | 37.785571094386 | -122.390446562985 | (37.785571094386, -122.390446562985) | |||
| 16189 | 16189 | 19840 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY25 | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 45841 | 45841 | 190426 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 24 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017676.692919999 | 2097082.9618400002 | 37.7391814722423 | -122.381398348955 | (37.7391814722423, -122.381398348955) | |||
| 103285 | 103285 | 48367 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.76541008749211 | -122.402712708416 | (37.7654100874921, -122.402712708416) | |||
| 107899 | 107899 | 6481 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2004 12:00:00 AM | 3 | 3X3 | 6017370.51401 | 2097316.59001 | 37.7398060600402 | -122.38247323921001 | (37.7398060600402, -122.38247323921) | ||
| 50394 | 50394 | 190425 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 23 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017693.17965 | 2097070.35958 | 37.739147779140396 | -122.38134046861299 | (37.7391477791404, -122.381340468613) | |||
| 81117 | 81117 | 48370 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.76541008749211 | -122.402712708416 | (37.7654100874921, -122.402712708416) | |||
| 122398 | 122398 | 6482 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6017388.40501 | 2097301.08401 | 37.739764471951396 | -122.38241030049801 | (37.7397644719514, -122.382410300498) | ||
| 109991 | 109991 | 48374 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.76541008749211 | -122.402712708416 | (37.7654100874921, -122.402712708416) | |||
| 157330 | 157330 | 190424 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 22 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017710.59589 | 2097057.73864 | 37.7391140860314 | -122.38127937316901 | (37.7391140860314, -122.381279373169) | |||
| 99684 | 99684 | 48391 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.76541008749211 | -122.402712708416 | (37.7654100874921, -122.402712708416) | |||
| 164173 | 164173 | 190423 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 21 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017743.92086 | 2097032.31488 | 37.739046117095704 | -122.381162382138 | (37.7390461170957, -122.381162382138) | |||
| 111155 | 111155 | 48390 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.76541008749211 | -122.402712708416 | (37.7654100874921, -122.402712708416) | |||
| 119286 | 119286 | 6478 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2013 12:00:00 AM | 3 | 3x3 | 6017452.81601 | 2097250.98701 | 37.739630473342 | -122.382184108102 | (37.739630473342, -122.382184108102) | ||
| 59123 | 59123 | 139213 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2011 Post St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6002512.7578 | 2114020.0754 | 37.784837850726 | -122.43503935352301 | (37.784837850726, -122.435039353523) | |||
| 124353 | 124353 | 48389 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.76541008749211 | -122.402712708416 | (37.7654100874921, -122.402712708416) | |||
| 41276 | 41276 | 128931 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2101 Washington St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6004999.26308 | 2116762.74652 | 37.79250941163579 | -122.42663222261999 | (37.7925094116358, -122.42663222262) | |||
| 52901 | 52901 | 190422 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 18 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6017797.18223 | 2096994.0322599998 | 37.7389439406012 | -122.38097556597299 | (37.7389439406012, -122.380975565973) | |||
| 54869 | 54869 | 139212 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2021 Post St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002482.7947 | 2114015.795 | 37.7848243964441 | -122.435142709694 | (37.7848243964441, -122.435142709694) | |||
| 79314 | 79314 | 6476 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6017489.79301 | 2097227.1310099997 | 37.739567011757 | -122.38205459719299 | (37.739567011757, -122.382054597193) | ||
| 107734 | 107734 | 48388 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.76541008749211 | -122.402712708416 | (37.7654100874921, -122.402712708416) | |||
| 186829 | 186829 | 192496 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 301 Kansas St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6011473.84765 | 2106919.34293 | 37.765845622699 | -122.403536974176 | (37.765845622699, -122.403536974176) | |||
| 44896 | 44896 | 190421 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 17 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017813.9736 | 2096980.8190099997 | 37.7389085864479 | -122.38091659022899 | (37.7389085864479, -122.380916590229) | |||
| 61161 | 61161 | 139211 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2031 Post St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002368.8281 | 2113997.6031 | 37.7847679739293 | -122.435535694505 | (37.7847679739293, -122.435535694505) | |||
| 77776 | 77776 | 39397 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
| 87959 | 87959 | 121284 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 369 18th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x15 | 5990184.0 | 2112906.0 | 37.781071152831004 | -122.477610920079 | (37.781071152831, -122.477610920079) | ||||
| 126845 | 126845 | 48387 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.76541008749211 | -122.402712708416 | (37.7654100874921, -122.402712708416) | |||
| 159633 | 159633 | 192480 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 301 Kansas St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6011473.03929 | 2106892.33623 | 37.7657714232394 | -122.403537869879 | (37.7657714232394, -122.403537869879) | |||
| 46420 | 46420 | 190420 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 16 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017827.78919 | 2096970.1308799998 | 37.7388800015007 | -122.380868079005 | (37.7388800015007, -122.380868079005) | |||
| 47932 | 47932 | 192481 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 301 Kansas St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6011473.76418 | 2106869.53362 | 37.7657088529051 | -122.403533758181 | (37.7657088529051, -122.403533758181) | |||
| 88763 | 88763 | 121283 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 369 18th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x15 | 5990184.0 | 2112906.0 | 37.781071152831004 | -122.477610920079 | (37.781071152831, -122.477610920079) | ||||
| 118564 | 118564 | 39389 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
| 135008 | 135008 | 48385 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | 5 | Permit Number 45774 | 6011713.252669999 | 2106604.5183099997 | 37.7649945546827 | -122.402686775779 | (37.7649945546827, -122.402686775779) | ||
| 40645 | 40645 | 190496 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 541 Delancey St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6015207.26145 | 2113719.36295 | 37.7847247945658 | -122.39109911375799 | (37.7847247945658, -122.391099113758) | |||
| 49308 | 49308 | 192495 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 301 Kansas St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6011476.27694 | 2106815.84038 | 37.7655615637291 | -122.40352128908701 | (37.7655615637291, -122.403521289087) | |||
| 51798 | 51798 | 48384 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | 5 | Permit Number 45774 | 6011713.07765 | 2106631.21617 | 37.7650678512362 | -122.40268925880301 | (37.7650678512362, -122.402689258803) | ||
| 69537 | 69537 | 190414 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012337.1891 | 2100920.23068 | 37.7494215649704 | -122.400129481597 | (37.7494215649704, -122.400129481597) | |||
| 71446 | 71446 | 128930 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2101 Washington St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004894.46746 | 2116746.04184 | 37.792457619672 | -122.42699362866199 | (37.792457619672, -122.426993628662) | |||
| 94711 | 94711 | 121282 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 369 18th Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x15 | 5990184.0 | 2112906.0 | 37.781071152831004 | -122.477610920079 | (37.781071152831, -122.477610920079) | ||||
| 123381 | 123381 | 39391 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
| 132626 | 132626 | 219123 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Brompton Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002016.155119999 | 2095016.1779599998 | 37.7326295343225 | -122.435397547681 | (37.7326295343225, -122.435397547681) | |||
| 141946 | 141946 | 6433 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1100X Evans Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/10/2014 12:00:00 AM | 3 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | ||
| 147177 | 147177 | 190419 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 15 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017844.32202 | 2096957.74462 | 37.7388469037738 | -122.380810054756 | (37.7388469037738, -122.380810054756) | |||
| 149010 | 149010 | 190411 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 15 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012337.1891 | 2100920.23068 | 37.7494215649704 | -122.400129481597 | (37.7494215649704, -122.400129481597) | |||
| 172466 | 172466 | 190413 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012337.1891 | 2100920.23068 | 37.7494215649704 | -122.400129481597 | (37.7494215649704, -122.400129481597) | |||
| 184752 | 184752 | 190412 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 15 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012337.1891 | 2100920.23068 | 37.7494215649704 | -122.400129481597 | (37.7494215649704, -122.400129481597) | |||
| 15992 | 15992 | 4049 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6012317.265430001 | 2100919.43782 | 37.749418277035296 | -122.400198322911 | (37.7494182770353, -122.400198322911) | |||
| 27041 | 27041 | 192494 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 301 Kansas St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011476.962069999 | 2106788.73124 | 37.765487166410296 | -122.40351701192301 | (37.7654871664103, -122.403517011923) | |||
| 33816 | 33816 | 48383 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | 5 | Permit Number 45774 | 6011710.50026 | 2106657.48632 | 37.7651398392626 | -122.40270002101299 | (37.7651398392626, -122.402700021013) | ||
| 71710 | 71710 | 190409 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 14 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012317.265430001 | 2100919.43782 | 37.749418277035296 | -122.400198322911 | (37.7494182770353, -122.400198322911) | |||
| 101250 | 101250 | 39393 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
| 131934 | 131934 | 190410 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012317.265430001 | 2100919.43782 | 37.749418277035296 | -122.400198322911 | (37.7494182770353, -122.400198322911) | |||
| 138526 | 138526 | 121281 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 369 18th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x15 | 5990184.0 | 2112906.0 | 37.781071152831004 | -122.477610920079 | (37.781071152831, -122.477610920079) | ||||
| 160828 | 160828 | 190495 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 541 Delancey St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015210.04745 | 2113708.9413099997 | 37.7846963337125 | -122.391088746357 | (37.7846963337125, -122.391088746357) | |||
| 173189 | 173189 | 219122 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Brompton Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002020.049930001 | 2095030.436 | 37.7326689048259 | -122.43538510194901 | (37.7326689048259, -122.435385101949) | |||
| 177267 | 177267 | 128929 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2101 Washington St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004845.70245 | 2116743.27362 | 37.7924472612924 | -122.42716215983 | (37.7924472612924, -122.42716215983) | |||
| 15660 | 15660 | 4048 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6012292.256030001 | 2100918.21603 | 37.74941352772171 | -122.40028472078998 | (37.7494135277217, -122.40028472079) | |||
| 28311 | 28311 | 139207 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2071 Post St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002142.068 | 2113965.1028 | 37.7846658547261 | -122.436317881839 | (37.7846658547261, -122.436317881839) | |||
| 53438 | 53438 | 190407 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 13 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012292.256030001 | 2100918.21603 | 37.74941352772171 | -122.40028472078998 | (37.7494135277217, -122.40028472079) | |||
| 69131 | 69131 | 190517 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 649 Delancey St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6015620.20689 | 2113286.09542 | 37.7835580465152 | -122.389640175967 | (37.7835580465152, -122.389640175967) | |||
| 75443 | 75443 | 190408 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012292.256030001 | 2100918.21603 | 37.74941352772171 | -122.40028472078998 | (37.7494135277217, -122.40028472079) | |||
| 88797 | 88797 | 44190 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
| 102084 | 102084 | 6473 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2001 12:00:00 AM | 3 | 3X3 | 6017566.13101 | 2097162.72001 | 37.7393943676917 | -122.38178617198099 | (37.7393943676917, -122.381786171981) | ||
| 114255 | 114255 | 39394 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1690 Church St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.74384312179429 | -122.42677419677099 | (37.7438431217943, -122.426774196771) | |||
| 131859 | 131859 | 128928 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2101 Washington St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004782.20902 | 2116734.88051 | 37.792420625168795 | -122.427381250838 | (37.7924206251688, -122.427381250838) | |||
| 140929 | 140929 | 121280 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 369 18th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x15 | 5990184.0 | 2112906.0 | 37.781071152831004 | -122.477610920079 | (37.781071152831, -122.477610920079) | ||||
| 150465 | 150465 | 190494 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 541 Delancey St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6015224.29962 | 2113700.39003 | 37.7846736447102 | -122.39103884028499 | (37.7846736447102, -122.391038840285) | |||
| 150793 | 150793 | 190418 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 13 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6017880.91866 | 2096930.7090099999 | 37.7387746891043 | -122.38068164054701 | (37.7387746891043, -122.380681640547) | |||
| 165704 | 165704 | 48382 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 350& 17th ST Rhode Island St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2002 12:00:00 AM | 6 | Permit Number 45774 | 6011708.87985 | 2106683.73701 | 37.7652118272854 | -122.402707471892 | (37.7652118272854, -122.402707471892) | ||
| 169156 | 169156 | 219121 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Brompton Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002025.50342 | 2095049.38545 | 37.7327212453836 | -122.43536760293699 | (37.7327212453836, -122.435367602937) |
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");