Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44681 | 44681 | 225910 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 99 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6005408.28506 | 2103204.3544 | 37.7553044666341 | -122.42425226303101 | (37.7553044666341, -122.424252263031) | |||
| 134421 | 134421 | 225909 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 99 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6005410.68329 | 2103188.80406 | 37.755261904439394 | -122.424242863321 | (37.7552619044394, -122.424242863321) | |||
| 19086 | 19086 | 10155 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 988 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6005676.86794 | 2103220.79798 | 37.7553647787894 | -122.423324590769 | (37.7553647787894, -122.423324590769) | |||
| 19073 | 19073 | 10152 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 981 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005742.33218 | 2103287.1896599997 | 37.7555507693625 | -122.42310291418801 | (37.7555507693625, -122.423102914188) | |||
| 89137 | 89137 | 95571 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 960 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767362 | 6003109.0 | 2102648.0 | 37.753646751876296 | -122.43216414381901 | (37.7536467518763, -122.432164143819) | |
| 4435 | 4435 | 34068 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 6607 | 6607 | 34069 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 7043 | 7043 | 34072 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 9590 | 9590 | 34067 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 10500 | 10500 | 34071 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 12798 | 12798 | 34070 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 107237 | 107237 | 65670 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 954 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28590 | 5998557.99448518 | 2095716.03586207 | 37.7343541747365 | -122.44740356075899 | (37.7343541747365, -122.447403560759) | ||
| 113742 | 113742 | 35091 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 920 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 15 | 3x3 | Permit Number 42238 | 5992055.93239281 | 2105259.4330846 | 37.760184186645105 | -122.47057793992701 | (37.7601841866451, -122.470577939927) |
| 122436 | 122436 | 35092 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 920 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1998 12:00:00 AM | 25 | 3x3 | Permit Number 38633 | 5992055.93239281 | 2105259.4330846 | 37.760184186645105 | -122.47057793992701 | (37.7601841866451, -122.470577939927) | |
| 92783 | 92783 | 50169 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 89@ DUBOCE Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2003 12:00:00 AM | Permit Number 46880 | 6001684.35285968 | 2108342.8233287 | 37.7692024719005 | -122.437498663894 | (37.7692024719005, -122.437498663894) | |||
| 17889 | 17889 | 10131 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 899 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005716.194490001 | 2103799.35315 | 37.7569555760466 | -122.42322971137699 | (37.7569555760466, -122.423229711377) | ||
| 18959 | 18959 | 10130 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 899 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005717.32362 | 2103778.4665900003 | 37.7568982901448 | -122.423224321766 | (37.7568982901448, -122.423224321766) | ||
| 22152 | 22152 | 10132 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 899 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005714.0796 | 2103814.39751 | 37.756996764997 | -122.42323809485599 | (37.756996764997, -122.423238094856) | ||
| 144515 | 144515 | 10133 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 899 Guerrero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005711.897824 | 2103735.5027185003 | 37.756780015162896 | -122.42324003225401 | (37.7567800151629, -122.423240032254) | ||
| 32129 | 32129 | 225911 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 886 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6005643.7507 | 2103817.72642 | 37.75700193611971 | -122.42348155572999 | (37.7570019361197, -122.42348155573) | |||
| 90002 | 90002 | 10124 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 877 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005714.7162163 | 2103867.2939474997 | 37.7571420422058 | -122.42323965318998 | (37.7571420422058, -122.42323965319) | |||
| 13795 | 13795 | 78433 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 870 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2016 12:00:00 AM | 3 | 6011558.925919999 | 2104265.3143 | 37.7585630053957 | -122.403056007737 | (37.7585630053957, -122.403056007737) | ||
| 135744 | 135744 | 192407 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 862 Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011557.46585 | 2104307.68727 | 37.758679270636 | -122.403064037781 | (37.758679270636, -122.403064037781) | |||
| 61102 | 61102 | 225917 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 85 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005793.09116 | 2104012.0395299997 | 37.757543902632605 | -122.42297888958099 | (37.7575439026326, -122.422978889581) | |||
| 117059 | 117059 | 35576 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 85 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38944 | 6005785.83921356 | 2104003.6408016 | 37.7575204324701 | -122.42300337283999 | (37.7575204324701, -122.42300337284) | ||
| 20284 | 20284 | 10112 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 821 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6005694.086069999 | 2104163.28117 | 37.7579535897166 | -122.423332040744 | (37.7579535897166, -122.423332040744) | |||
| 44495 | 44495 | 225965 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 81 Bernal Heights Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009494.27227 | 2098224.22173 | 37.74185999325589 | -122.409770124916 | (37.7418599932559, -122.409770124916) | |||
| 27127 | 27127 | 225952 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 800 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001178.257669999 | 2102625.59939 | 37.753475588250396 | -122.438839459988 | (37.7534755882504, -122.438839459988) | |||
| 153007 | 153007 | 192422 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 80 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6012207.07921 | 2107722.19142 | 37.768090993327704 | -122.401057281578 | (37.7680909933277, -122.401057281578) | |||
| 168988 | 168988 | 192423 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 80 Carolina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6012208.345290001 | 2107668.53767 | 37.76794374283679 | -122.401049131921 | (37.7679437428368, -122.401049131921) | |||
| 171362 | 171362 | 192424 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 80 Carolina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6012214.215580001 | 2107593.00345 | 37.767736670334 | -122.40102351921401 | (37.767736670334, -122.401023519214) | |||
| 25421 | 25421 | 192408 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 799 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011594.92882 | 2104699.3900200003 | 37.759756891395796 | -122.40296202319999 | (37.7597568913958, -122.4029620232) | |||
| 116317 | 116317 | 114483 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 784 CLEMENTINA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x2 | 6009096.0 | 2110140.0 | 37.7745556909018 | -122.41198909995701 | (37.7745556909018, -122.411989099957) | |||
| 163115 | 163115 | 112711 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 782 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 1 | 6009126.82605 | 2110111.36785 | 37.774478803191 | -122.411880442527 | (37.774478803191, -122.411880442527) | ||
| 33224 | 33224 | 32625 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 75 Boardman Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 15 | Permit Number 37080 | 6011878.08124 | 2109949.48586 | 37.774188278987204 | -122.402351882652 | (37.7741882789872, -122.402351882652) | |
| 38696 | 38696 | 32626 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 75 Boardman Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 14 | Permit Number 37080 | 6011867.62207 | 2109962.18755 | 37.7742225710588 | -122.402388956281 | (37.7742225710588, -122.402388956281) | |
| 76617 | 76617 | 32627 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 75 Boardman Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 15 | Permit Number 37080 | 6011835.142990001 | 2109991.00563 | 37.774299885758 | -122.40250333475599 | (37.774299885758, -122.402503334756) | |
| 29018 | 29018 | 247759 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 75 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6001668.74952 | 2108376.80716 | 37.7692948959648 | -122.437555068929 | (37.7692948959648, -122.437555068929) | |||
| 58427 | 58427 | 67493 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 740 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 8 | Permit Number 31018 | 6011800.9294 | 2105019.52264 | 37.760647405471204 | -122.402272073209 | (37.7606474054712, -122.402272073209) | |
| 154338 | 154338 | 192414 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 740 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6011806.79674 | 2104934.73644 | 37.76041492892529 | -122.40224581930799 | (37.7604149289253, -122.402245819308) | |||
| 184026 | 184026 | 225978 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 737 Sanchez St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 6003705.65415 | 2103955.3434599997 | 37.757270218256394 | -122.430194042444 | (37.7572702182564, -122.430194042444) | |||
| 131813 | 131813 | 82990 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 737 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50125 | 6009298.17418 | 2110240.35937 | 37.774842595135205 | -122.41129682837901 | (37.7748425951352, -122.411296828379) | |
| 36158 | 36158 | 65448 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 72 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/1989 12:00:00 AM | 9 | Permit Number 28322 | 5994279.76671 | 2115099.7417900003 | 37.7873314010144 | -122.46360098807399 | (37.7873314010144, -122.463600988074) | ||
| 154398 | 154398 | 82843 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 719 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52435 | 6009401.3474 | 2110338.98679 | 37.7751191888227 | -122.410946896775 | (37.7751191888227, -122.410946896775) | |
| 130263 | 130263 | 192406 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 718 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6012081.21103 | 2105020.2958 | 37.7606651697825 | -122.401302754214 | (37.7606651697825, -122.401302754214) | ||||
| 18217 | 18217 | 10091 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 708 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/1992 12:00:00 AM | 50 | 3X3 | 6005589.43333 | 2104821.82229 | 37.759755882347704 | -122.42374079792299 | (37.7597558823477, -122.423740797923) | ||
| 20175 | 20175 | 10089 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 700 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005586.51976 | 2104851.24563 | 37.7598365074586 | -122.423752966647 | (37.7598365074586, -122.423752966647) | |||
| 154809 | 154809 | 225913 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 699 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005644.87336 | 2104976.18097 | 37.760182844481 | -122.42356003238501 | (37.760182844481, -122.423560032385) | |||
| 153603 | 153603 | 128862 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 689 Hayes St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004674.24665 | 2110845.64244 | 37.7762441372985 | -122.427335092236 | (37.7762441372985, -122.427335092236) | |||
| 130809 | 130809 | 142235 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 689 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004665.6696 | 2110849.8982 | 37.7762553374912 | -122.42736506585 | (37.7762553374912, -122.42736506585) | |||
| 90319 | 90319 | 421 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 685X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005653.198434 | 2104994.6037312 | 37.7602338989595 | -122.423532549649 | (37.7602338989595, -122.423532549649) | |||
| 21466 | 21466 | 10087 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 673 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X2 | 6005642.33302 | 2105078.4944700003 | 37.7604636299235 | -122.423576092482 | (37.7604636299235, -122.423576092482) | |||
| 116480 | 116480 | 94704 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 670 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53844 | 5992265.910069999 | 2110887.9473900003 | 37.7756507238334 | -122.470261618584 | (37.7756507238334, -122.470261618584) |
| 58425 | 58425 | 67551 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 655 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 8 | Permit Number 31099 | 6011561.87177 | 2105285.59303 | 37.761364628288604 | -122.403117586111 | (37.7613646282886, -122.403117586111) | |
| 39742 | 39742 | 192410 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011779.1081300005 | 2105360.6424 | 37.761582826304604 | -122.402371529224 | (37.7615828263046, -122.402371529224) | |||
| 40705 | 40705 | 192411 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011779.44506 | 2105347.31232 | 37.7615462436837 | -122.40236942660499 | (37.7615462436837, -122.402369426605) | |||
| 41412 | 41412 | 192412 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011780.95507 | 2105331.83928 | 37.761503842456605 | -122.402363116082 | (37.7615038424566, -122.402363116082) | |||
| 60881 | 60881 | 192409 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6011776.86645 | 2105375.28628 | 37.7616229099979 | -122.40238031202 | (37.7616229099979, -122.40238031202) | |||
| 156793 | 156793 | 192413 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 5 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011782.001 | 2105308.50285 | 37.7614398242054 | -122.402357857724 | (37.7614398242054, -122.402357857724) | |||
| 73383 | 73383 | 225950 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 646 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001193.5542 | 2102647.97152 | 37.7535378869843 | -122.438788164466 | (37.7535378869843, -122.438788164466) | |||
| 6485 | 6485 | 29768 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 640 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/1991 12:00:00 AM | 6 | 6x6 | 6008286.5569 | 2121053.0319999997 | 37.8044747652934 | -122.415561939011 | (37.8044747652934, -122.415561939011) | ||
| 79560 | 79560 | 7700 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 640 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x6 | 6008187.1407969 | 2121043.7620312 | 37.804443723648895 | -122.415905321467 | (37.8044437236489, -122.415905321467) | |||
| 31018 | 31018 | 244415 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 630 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003443.0612 | 2109684.1199 | 37.7729851758016 | -122.43151115772899 | (37.7729851758016, -122.431511157729) | |||
| 59849 | 59849 | 128863 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 628 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004545.79116 | 2110745.60377 | 37.7759621899439 | -122.42777232553499 | (37.7759621899439, -122.427772325535) | |||
| 183419 | 183419 | 128864 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 628 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6004541.11924 | 2110775.90598 | 37.7760451281037 | -122.42779064652599 | (37.7760451281037, -122.427790646526) | |||
| 133410 | 133410 | 59942 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 625 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 13 | Permit Number 19416 | 5999638.7469 | 2110673.4971 | 37.775485398815796 | -122.444741829234 | (37.7754853988158, -122.444741829234) | |
| 129468 | 129468 | 32983 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 618 Texas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | ||
| 121204 | 121204 | 68770 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 616 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1993 12:00:00 AM | Permit Number 32698 | 6002993.73826974 | 2104676.98539815 | 37.7592113259791 | -122.432707672319 | (37.7592113259791, -122.432707672319) | ||
| 162995 | 162995 | 79749 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 615 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 9 | 6015454.74686 | 2106112.32495 | 37.7638512843329 | -122.38971139058799 | (37.7638512843329, -122.389711390588) | ||
| 28224 | 28224 | 48556 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 615 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/23/2002 12:00:00 AM | 3 | Permit Number 45872 | 5999645.29400405 | 2110579.50430317 | 37.7752276921804 | -122.444712423834 | (37.7752276921804, -122.444712423834) | |
| 17382 | 17382 | 10079 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 614 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6005561.0033 | 2105378.47551 | 37.7612827162343 | -122.423878706238 | (37.7612827162343, -122.423878706238) | |||
| 178778 | 178778 | 225914 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 611 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009855.21876 | 2105398.0408099997 | 37.7615779286091 | -122.409028144648 | (37.7615779286091, -122.409028144648) | |||
| 142869 | 142869 | 116342 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 611 YORK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778005 | 6009887.0 | 2105445.0 | 37.7617086481783 | -122.40892153916599 | (37.7617086481783, -122.408921539166) | |
| 185706 | 185706 | 67574 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 601 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 13 | Permit Number 31129 | 6013300.57075 | 2104280.61777 | 37.7587021305084 | -122.397033645504 | (37.7587021305084, -122.397033645504) | |
| 21621 | 21621 | 10076 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 600 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2x2 | 6005555.84644 | 2105437.30746 | 37.7614439637781 | -122.423900725242 | (37.7614439637781, -122.423900725242) | |||
| 173505 | 173505 | 142723 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 600 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6008387.4711 | 2121064.7168 | 37.8045125206489 | -122.415213542996 | (37.8045125206489, -122.415213542996) | |||
| 178516 | 178516 | 142724 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 600 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008368.8817 | 2121063.6546 | 37.804508559383706 | -122.41527779826299 | (37.8045085593837, -122.415277798263) | |||
| 147884 | 147884 | 142233 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 600 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004546.0223 | 2110772.1475 | 37.7760350855974 | -122.427773417679 | (37.7760350855974, -122.427773417679) | |||
| 167999 | 167999 | 142232 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 600 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004552.0651 | 2110734.2793 | 37.775931450627205 | -122.427749815271 | (37.7759314506272, -122.427749815271) | |||
| 133714 | 133714 | 49835 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 587 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 11 | Permit Number 46618 | 6014427.95757 | 2104386.8638299997 | 37.759056552429705 | -122.393142029905 | (37.7590565524297, -122.393142029905) | |
| 6875 | 6875 | 26546 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 570 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/1997 12:00:00 AM | 6 | 4X4 | 6008578.3106 | 2121094.8201 | 37.804605899968 | -122.41455525494301 | (37.804605899968, -122.414555254943) | ||
| 87311 | 87311 | 29766 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 570 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6008571.0386595 | 2121096.2836166 | 37.8046095098754 | -122.414580523895 | (37.8046095098754, -122.414580523895) | |||
| 121812 | 121812 | 29765 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 570 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6008571.0386595 | 2121096.2836166 | 37.8046095098754 | -122.414580523895 | (37.8046095098754, -122.414580523895) | |||
| 139606 | 139606 | 26547 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 570 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1999 12:00:00 AM | 6 | 4X4 | 6008571.0386595 | 2121096.2836166 | 37.8046095098754 | -122.414580523895 | (37.8046095098754, -122.414580523895) | ||
| 19478 | 19478 | 10071 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 563 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x3 | 6005607.25335 | 2105721.20389 | 37.7622263784702 | -122.423743116346 | (37.7622263784702, -122.423743116346) | |||
| 136892 | 136892 | 142690 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 560 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008610.8035 | 2121097.1003 | 37.804613986225704 | -122.41444297124599 | (37.8046139862257, -122.414442971246) | |||
| 164420 | 164420 | 225929 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 56 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008145.90084 | 2098385.005 | 37.742225813165895 | -122.414443742389 | (37.7422258131659, -122.414443742389) | |||
| 122979 | 122979 | 37469 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 557 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39940 | 6009863.21581356 | 2098931.68283254 | 37.7438231962188 | -122.408544326388 | (37.7438231962188, -122.408544326388) | ||
| 158982 | 158982 | 225932 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 557 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009854.01904 | 2098898.01508 | 37.743730236853 | -122.40857375230101 | (37.743730236853, -122.408573752301) | |||
| 133659 | 133659 | 142688 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 552 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6008641.5861 | 2121102.2307 | 37.8046298022358 | -122.414336807992 | (37.8046298022358, -122.414336807992) | |||
| 186722 | 186722 | 142687 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 550 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6008655.2673 | 2121104.5109 | 37.804636831606494 | -122.414289624157 | (37.8046368316065, -122.414289624157) | |||
| 106266 | 106266 | 65468 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 55 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1989 12:00:00 AM | Permit Number 28348 | 5995598.18541989 | 2090265.07086982 | 37.7192175521634 | -122.457242320925 | (37.7192175521634, -122.457242320925) | ||
| 20893 | 20893 | 10068 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 549 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x3 | 6005603.73706 | 2105778.3330099997 | 37.762383043055 | -122.423759340124 | (37.762383043055, -122.423759340124) | |||
| 70095 | 70095 | 59933 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 549 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 9 | Permit Number 19406 | 5999664.8686 | 2110448.6759 | 37.77486958773171 | -122.444635305779 | (37.7748695877317, -122.444635305779) | |
| 154958 | 154958 | 112871 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 549 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11 | 5999666.6578 | 2110431.976 | 37.7748238361568 | -122.444627916028 | (37.7748238361568, -122.444627916028) | |||
| 39534 | 39534 | 244202 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 546 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6003923.0756 | 2109749.7244 | 37.7731925042221 | -122.429855409854 | (37.7731925042221, -122.429855409854) | |||
| 66905 | 66905 | 244210 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 546 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003934.6479 | 2109752.6175 | 37.7732011032912 | -122.429815586143 | (37.7732011032912, -122.429815586143) | |||
| 90827 | 90827 | 93902 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 546 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2011 12:00:00 AM | 3x3 | Permit Number 768056 | 6003947.0 | 2109752.0 | 37.773200107256606 | -122.42977281454901 | (37.7732001072566, -122.429772814549) | ||
| 117209 | 117209 | 35153 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 546 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38684 | 6003946.04415605 | 2109759.28063083 | 37.7732200439593 | -122.429776640335 | (37.7732200439593, -122.429776640335) | ||
| 93765 | 93765 | 52137 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 541 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2005 12:00:00 AM | 4 | 3x3 | Permit Number 48316 | 6003127.26918681 | 2110108.47893411 | 37.774132457488896 | -122.432633838295 | (37.7741324574889, -122.432633838295) |
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");