Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87941 | 87941 | 44245 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 10 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2001 12:00:00 AM | Permit Number 43680 | 6010447.16728471 | 2099896.56831072 | 37.7465052482739 | -122.406593130128 | (37.7465052482739, -122.406593130128) | |||
| 71075 | 71075 | 106808 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 10 LOYOLA TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 772884 | 5998469.3 | 2110801.2 | 37.7757692329232 | -122.44879640789101 | (37.7757692329232, -122.448796407891) | |||
| 84824 | 84824 | 106999 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 10 Loyola Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998469.2817 | 2110801.2236 | 37.7757692966762 | -122.448796472896 | (37.7757692966762, -122.448796472896) | |||||
| 110441 | 110441 | 28300 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 100 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 5995887.0 | 2088090.0 | 37.713261901345 | -122.45608683538099 | (37.713261901345, -122.456086835381) | |||
| 99209 | 99209 | 94566 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998051.0 | 2107197.0 | 37.765849093366796 | -122.449983584058 | (37.7658490933668, -122.449983584058) | ||||
| 108733 | 108733 | 94567 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Carl St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998051.0 | 2107197.0 | 37.765849093366796 | -122.449983584058 | (37.7658490933668, -122.449983584058) | ||||
| 94766 | 94766 | 4593 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6011460.12974 | 2118136.30046 | 37.7966440043551 | -122.40437402195299 | (37.7966440043551, -122.404374021953) | |||
| 19751 | 19751 | 96542 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | ||||
| 106582 | 106582 | 96541 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | ||||
| 80353 | 80353 | 18304 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 100 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6010232.4387225 | 2107842.1672579 | 37.768310067349894 | -122.407895847634 | (37.7683100673499, -122.407895847634) | |||
| 87094 | 87094 | 18306 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 100 Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6010232.4387225 | 2107842.1672579 | 37.768310067349894 | -122.407895847634 | (37.7683100673499, -122.407895847634) | |||
| 1383 | 1383 | 26841 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 100 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 779930 | 6006975.88726 | 2110943.04151 | 37.7766414730488 | -122.419379980819 | (37.7766414730488, -122.419379980819) | ||
| 78224 | 78224 | 7218 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1000X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.43171763216101 | (37.778666518442, -122.431717632161) | |||
| 95841 | 95841 | 7215 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1000X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.43171763216101 | (37.778666518442, -122.431717632161) | |||
| 96630 | 96630 | 7221 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1000X Fillmore St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.43171763216101 | (37.778666518442, -122.431717632161) | |||
| 104564 | 104564 | 7220 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1000X Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.43171763216101 | (37.778666518442, -122.431717632161) | |||
| 108640 | 108640 | 7217 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1000X Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.43171763216101 | (37.778666518442, -122.431717632161) | |||
| 110796 | 110796 | 7216 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1000X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.43171763216101 | (37.778666518442, -122.431717632161) | |||
| 124303 | 124303 | 10573 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1000X Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 4x4 | 6011301.87316 | 2111047.97507 | 37.7771722946398 | -122.404422436991 | (37.7771722946398, -122.404422436991) | |||
| 80661 | 80661 | 107839 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1000x LEAVENWORTH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008256.0 | 2115925.0 | 37.790392745036 | -122.41530444395501 | (37.790392745036, -122.415304443955) | ||||
| 113594 | 113594 | 107836 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1000x LEAVENWORTH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008256.0 | 2115925.0 | 37.790392745036 | -122.41530444395501 | (37.790392745036, -122.415304443955) | |||
| 80416 | 80416 | 17013 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1001 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002208.6674 | 2109818.8585900003 | 37.773285094559895 | -122.43579071263001 | (37.7732850945599, -122.43579071263) | |||
| 100176 | 100176 | 17014 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1001 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002208.6674 | 2109818.8585900003 | 37.773285094559895 | -122.43579071263001 | (37.7732850945599, -122.43579071263) | |||
| 121221 | 121221 | 17011 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1001 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002208.6674 | 2109818.8585900003 | 37.773285094559895 | -122.43579071263001 | (37.7732850945599, -122.43579071263) | |||
| 3698 | 3698 | 20141 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1001 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002903.1358 | 2111776.1473 | 37.7786987467479 | -122.433528357436 | (37.7786987467479, -122.433528357436) | |||
| 92975 | 92975 | 7222 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1005 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003381.12091 | 2111775.83058 | 37.778724984986205 | -122.43187479969801 | (37.7787249849862, -122.431874799698) | |||
| 141132 | 141132 | 10578 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1005X HARRISON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x7 | 6011386.0 | 2111037.0 | 37.7771468605476 | -122.404130641378 | (37.7771468605476, -122.404130641378) | |||
| 18363 | 18363 | 94569 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100@ Cole Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998051.0 | 2107197.0 | 37.765849093366796 | -122.449983584058 | (37.7658490933668, -122.449983584058) | ||||
| 114137 | 114137 | 7225 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1015 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5x5 | 6003380.095 | 2111793.84702 | 37.7787743954893 | -122.431879635495 | (37.7787743954893, -122.431879635495) | |||
| 119954 | 119954 | 26666 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1015 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5992306.14573 | 2114757.6166 | 37.78627810348571 | -122.47040431482401 | (37.7862781034857, -122.470404314824) | |||
| 78830 | 78830 | 17674 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1015X Pierce St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002359.74374 | 2112046.46454 | 37.7794101245475 | -122.435427501131 | (37.7794101245475, -122.435427501131) | |||
| 79524 | 79524 | 112827 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 101X COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6011274.0 | 2118052.0 | 37.796402132688605 | -122.405012137355 | (37.7964021326886, -122.405012137355) | |||
| 112604 | 112604 | 112826 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 101X COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6011274.0 | 2118052.0 | 37.796402132688605 | -122.405012137355 | (37.7964021326886, -122.405012137355) | |||
| 113142 | 113142 | 112828 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 101X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6011274.0 | 2118052.0 | 37.796402132688605 | -122.405012137355 | (37.7964021326886, -122.405012137355) | |||
| 141721 | 141721 | 112825 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 101X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6011274.0 | 2118052.0 | 37.796402132688605 | -122.405012137355 | (37.7964021326886, -122.405012137355) | |||
| 126093 | 126093 | 121625 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 101x Trenton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010049.0 | 2117862.0 | 37.7958118850813 | -122.409237502382 | (37.7958118850813, -122.409237502382) | ||||
| 138425 | 138425 | 121624 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 101x Trenton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010049.0 | 2117862.0 | 37.7958118850813 | -122.409237502382 | (37.7958118850813, -122.409237502382) | ||||
| 88132 | 88132 | 18444 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1020 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6010472.2950908 | 2103284.5044843 | 37.7558091798762 | -122.40674496371099 | (37.7558091798762, -122.406744963711) | |||
| 143922 | 143922 | 18445 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1024 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6010473.6370906 | 2103261.6949103 | 37.7557466249525 | -122.406738715199 | (37.7557466249525, -122.406738715199) | |||
| 105595 | 105595 | 7226 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1025 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003385.45092 | 2111827.8386 | 37.7788680315263 | -122.431863535021 | (37.7788680315263, -122.431863535021) | |||
| 121345 | 121345 | 7227 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1025 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003385.45092 | 2111827.8386 | 37.7788680315263 | -122.431863535021 | (37.7788680315263, -122.431863535021) | |||
| 99171 | 99171 | 7234 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1035 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003369.22487 | 2111874.56942 | 37.778995422883796 | -122.431923005031 | (37.7789954228838, -122.431923005031) | |||
| 111857 | 111857 | 18447 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1036 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6010477.630358401 | 2103193.8225196 | 37.7555604859056 | -122.406720122129 | (37.7555604859056, -122.406720122129) | |||
| 138803 | 138803 | 18446 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1036 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6010477.630358401 | 2103193.8225196 | 37.7555604859056 | -122.406720122129 | (37.7555604859056, -122.406720122129) | |||
| 88466 | 88466 | 7229 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1040 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6003407.8759699995 | 2111884.23201 | 37.7790241450036 | -122.431789985507 | (37.7790241450036, -122.431789985507) | |||
| 94062 | 94062 | 7228 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1040 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6003407.8759699995 | 2111884.23201 | 37.7790241450036 | -122.431789985507 | (37.7790241450036, -122.431789985507) | |||
| 106405 | 106405 | 7230 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1040 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003407.8759699995 | 2111884.23201 | 37.7790241450036 | -122.431789985507 | (37.7790241450036, -122.431789985507) | |||
| 110877 | 110877 | 7231 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1040 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003407.8759699995 | 2111884.23201 | 37.7790241450036 | -122.431789985507 | (37.7790241450036, -122.431789985507) | |||
| 114567 | 114567 | 121561 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1044 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6003754.0 | 2102206.0 | 37.7524696725481 | -122.42990206526301 | (37.7524696725481, -122.429902065263) | |||
| 139547 | 139547 | 7232 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1045 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003365.392000001 | 2111902.08022 | 37.779070743403295 | -122.431938229416 | (37.7790707434033, -122.431938229416) | |||
| 145865 | 145865 | 7233 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1045 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003367.24511 | 2111893.72513 | 37.779047907460296 | -122.431931222001 | (37.7790479074603, -122.431931222001) | |||
| 100759 | 100759 | 17017 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1047 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001994.16718 | 2109794.13406 | 37.7732050204621 | -122.436530926895 | (37.7732050204621, -122.436530926895) | |||
| 78462 | 78462 | 108945 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 105 Richland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | |||||
| 87077 | 87077 | 108943 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 105 Richland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | |||||
| 126681 | 126681 | 10586 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1050X Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 75 | 3X3 | 6011036.2882597 | 2110765.2479161 | 37.7763811461579 | -122.40532126913901 | (37.7763811461579, -122.405321269139) | |||
| 83892 | 83892 | 9617 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1050X Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002921.99888 | 2111973.13636 | 37.7792406996886 | -122.433477183837 | (37.7792406996886, -122.433477183837) | |||
| 85850 | 85850 | 9615 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1050X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002927.21435 | 2111923.58629 | 37.77910494348671 | -122.43345559949101 | (37.7791049434867, -122.433455599491) | |||
| 116795 | 116795 | 17019 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1053 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001967.47701 | 2109780.3340000003 | 37.773165612223394 | -122.436622263598 | (37.7731656122234, -122.436622263598) | |||
| 102525 | 102525 | 7235 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1055 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003361.88401 | 2111924.4180099997 | 37.7791318785406 | -122.431951960454 | (37.7791318785406, -122.431951960454) | |||
| 51508 | 51508 | 7237 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1065 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003359.4574 | 2111944.18191 | 37.7791860077197 | -122.431961766737 | (37.7791860077197, -122.431961766737) | |||
| 120622 | 120622 | 7236 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1065 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003355.08756 | 2111967.1389900004 | 37.7792487944095 | -122.431978523544 | (37.7792487944095, -122.431978523544) | |||
| 83639 | 83639 | 66275 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1065 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1990 12:00:00 AM | 3x3 | Permit Number 768678 | 6007678.31560988 | 2109516.6646006 | 37.7727645184447 | -122.416848989215 | (37.7727645184447, -122.416848989215) | ||
| 128782 | 128782 | 65045 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1066 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2004 12:00:00 AM | Permit Number 45972 | 6007827.74406772 | 2119607.84984942 | 37.8004808586212 | -122.41704724444901 | (37.8004808586212, -122.417047244449) | |||
| 89324 | 89324 | 57802 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 107 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1988 12:00:00 AM | 8 | 3x3 | Permit Number 25561 | 6000622.33928566 | 2102551.03510935 | 37.753239209170204 | -122.44075659160102 | (37.7532392091702, -122.440756591601) | |
| 90806 | 90806 | 4728 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1075 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6008196.257 | 2120907.2939400002 | 37.8040695291651 | -122.41586410452 | (37.8040695291651, -122.41586410452) | |||
| 127950 | 127950 | 4729 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1075 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6008196.257 | 2120907.2939400002 | 37.8040695291651 | -122.41586410452 | (37.8040695291651, -122.41586410452) | |||
| 109289 | 109289 | 5589 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1082 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6005080.54834 | 2102051.49498 | 37.7521204720239 | -122.425303641737 | (37.7521204720239, -122.425303641737) | |||
| 113700 | 113700 | 18451 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1082 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6010493.0142586 | 2102932.3469158 | 37.7548433927728 | -122.40664849396002 | (37.7548433927728, -122.40664849396) | |||
| 50078 | 50078 | 7238 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1085 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4X4 | 6003353.84267 | 2112023.38614 | 37.7794031644909 | -122.43198684768801 | (37.7794031644909, -122.431986847688) | |||
| 113389 | 113389 | 7239 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1085 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003353.76677 | 2111995.41321 | 37.7793263534941 | -122.431985112237 | (37.7793263534941, -122.431985112237) | |||
| 134152 | 134152 | 57410 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 109 Wilmot St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1976 12:00:00 AM | 15 | Permit Number 770100 | 6002753.5601 | 2114939.9175 | 37.7873771736852 | -122.434272041026 | (37.7873771736852, -122.434272041026) | ||
| 139997 | 139997 | 97109 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1095X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6003187.0 | 2102045.0 | 37.751995478526204 | -122.431851350128 | (37.7519954785262, -122.431851350128) | |||
| 142651 | 142651 | 97110 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1095X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6003193.9 | 2101874.0 | 37.751526344012 | -122.43181528051201 | (37.751526344012, -122.431815280512) | |||
| 114322 | 114322 | 17691 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1095X Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6002343.215339401 | 2112268.6379219 | 37.7800192180629 | -122.43550057779301 | (37.7800192180629, -122.435500577793) | |||
| 143425 | 143425 | 17693 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1095X Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6002343.215339401 | 2112268.6379219 | 37.7800192180629 | -122.43550057779301 | (37.7800192180629, -122.435500577793) | |||
| 80711 | 80711 | 120139 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 10X Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007842.0 | 2111812.0 | 37.779076168386105 | -122.41644540073798 | (37.7790761683861, -122.416445400738) | ||||
| 90905 | 90905 | 120135 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 10X Grove St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007842.0 | 2111812.0 | 37.779076168386105 | -122.41644540073798 | (37.7790761683861, -122.416445400738) | ||||
| 109453 | 109453 | 120140 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 10X Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007842.0 | 2111812.0 | 37.779076168386105 | -122.41644540073798 | (37.7790761683861, -122.416445400738) | ||||
| 109741 | 109741 | 120143 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 10X Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007842.0 | 2111812.0 | 37.779076168386105 | -122.41644540073798 | (37.7790761683861, -122.416445400738) | ||||
| 113538 | 113538 | 120138 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 10X Grove St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007842.0 | 2111812.0 | 37.779076168386105 | -122.41644540073798 | (37.7790761683861, -122.416445400738) | ||||
| 119162 | 119162 | 120136 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 10X Grove St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007842.0 | 2111812.0 | 37.779076168386105 | -122.41644540073798 | (37.7790761683861, -122.416445400738) | ||||
| 124679 | 124679 | 120137 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 10X Grove St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007842.0 | 2111812.0 | 37.779076168386105 | -122.41644540073798 | (37.7790761683861, -122.416445400738) | ||||
| 138516 | 138516 | 120141 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 10X Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007842.0 | 2111812.0 | 37.779076168386105 | -122.41644540073798 | (37.7790761683861, -122.416445400738) | ||||
| 141141 | 141141 | 120134 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 10X Grove St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007842.0 | 2111812.0 | 37.779076168386105 | -122.41644540073798 | (37.7790761683861, -122.416445400738) | ||||
| 142146 | 142146 | 120142 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 10X Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007842.0 | 2111812.0 | 37.779076168386105 | -122.41644540073798 | (37.7790761683861, -122.416445400738) | ||||
| 110876 | 110876 | 19491 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 10X Saroyan Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6010944.428590001 | 2118456.6911400002 | 37.79749488781339 | -122.406181056735 | (37.7974948878134, -122.406181056735) | |||
| 118945 | 118945 | 19490 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 10X Saroyan Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6010944.428590001 | 2118456.6911400002 | 37.79749488781339 | -122.406181056735 | (37.7974948878134, -122.406181056735) | |||
| 95993 | 95993 | 15110 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 110 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6014281.21891 | 2116519.09631 | 37.7923607834286 | -122.39449904952801 | (37.7923607834286, -122.394499049528) | |||
| 97704 | 97704 | 15109 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 110 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6014295.34515 | 2116528.26215 | 37.792386735981104 | -122.3944508141 | (37.7923867359811, -122.3944508141) | |||
| 106107 | 106107 | 15108 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 110 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6014309.51773 | 2116539.1619 | 37.7924174520023 | -122.394402539761 | (37.7924174520023, -122.394402539761) | |||
| 108666 | 108666 | 15106 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 110 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6014335.21568 | 2116559.29701 | 37.7924741668095 | -122.394315033873 | (37.7924741668095, -122.394315033873) | |||
| 120399 | 120399 | 15107 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 110 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6014322.846530001 | 2116550.9517900003 | 37.7924505652168 | -122.39435724725901 | (37.7924505652168, -122.394357247259) | |||
| 142097 | 142097 | 15105 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 110 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6014344.937609999 | 2116565.97781 | 37.7924930511311 | -122.394281863407 | (37.7924930511311, -122.394281863407) | |||
| 9915 | 9915 | 59271 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 110 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2017 12:00:00 AM | 3 | Permit Number 18607 | 6004280.88948873 | 2109181.36087728 | 37.7716521728269 | -122.428577162778 | (37.7716521728269, -122.428577162778) | ||
| 142870 | 142870 | 5595 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1100 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 6005095.523502599 | 2101950.1341989 | 37.75184300486389 | -122.425244643333 | (37.7518430048639, -122.425244643333) | |||
| 113997 | 113997 | 18453 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1101 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6010571.1211098 | 2102712.3512406996 | 37.754243703128296 | -122.40636287730499 | (37.7542437031283, -122.406362877305) | |||
| 119153 | 119153 | 110027 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1101X WEBSTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6003707.0 | 2112516.0 | 37.780775774357295 | -122.430800292528 | (37.7807757743573, -122.430800292528) | ||||
| 98476 | 98476 | 19217 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1103X Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002080.8485 | 2110141.50629 | 37.774163743397104 | -122.436255949697 | (37.7741637433971, -122.436255949697) | |||
| 99340 | 99340 | 113158 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1104 STANYAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997339.0 | 2106686.0 | 37.764405251212004 | -122.45240935159799 | (37.764405251212, -122.452409351598) | ||||
| 107951 | 107951 | 102235 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1104 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009987.0 | 2102770.0 | 37.754369300566296 | -122.408386989199 | (37.7543693005663, -122.408386989199) |
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");