Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 141 | 141 | 832 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1396 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:18:00 PM | 3 | 3X3 | 5981551.7086 | 2105613.8347 | 37.7605442750604 | -122.50693272862101 | (37.7605442750604, -122.506932728621) | ||
| 144 | 144 | 11598 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4134 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 11:51:00 AM | 3 | 3X3 | 5981663.7126 | 2105589.2786 | 37.760483446414796 | -122.506543543521 | (37.7604834464148, -122.506543543521) | ||
| 146 | 146 | 97319 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1038 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:52:00 PM | 3 | 3x3 | 5989945.5882 | 2099070.048 | 37.7430675136338 | -122.477424174253 | (37.7430675136338, -122.477424174253) | ||
| 147 | 147 | 58021 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4026 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:07:00 PM | 3 | Permit Number 16988 | 5983218.6194 | 2106316.5419 | 37.7625717348083 | -122.50121971656999 | (37.7625717348083, -122.50121971657) | ||
| 150 | 150 | 11606 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4200x Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 11:54:00 AM | 3 | 3X3 | 5981492.2847 | 2105581.1189 | 37.76045094714279 | -122.507135818078 | (37.7604509471428, -122.507135818078) | ||
| 152 | 152 | 24532 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1395 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:21:00 PM | 3 | 3X3 | 5981507.2257 | 2105680.0147 | 37.7607233666377 | -122.50709148147499 | (37.7607233666377, -122.507091481475) | ||
| 156 | 156 | 54712 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4508 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 11:58:00 AM | 3 | 3x3 | Permit Number 10547 | 5981730.2931 | 2106265.9364 | 37.762345274891 | -122.506363455406 | (37.762345274891, -122.506363455406) | |
| 159 | 159 | 97322 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1055 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:42:00 PM | 3 | 3x3 | 5989910.3078 | 2099001.0945 | 37.7428761380219 | -122.477541124233 | (37.7428761380219, -122.477541124233) | ||
| 164 | 164 | 97323 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1011 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:25:00 PM | 3 | 3x3 | 5990005.0659 | 2099005.494 | 37.7428937161431 | -122.477213802134 | (37.7428937161431, -122.477213802134) | ||
| 165 | 165 | 11582 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4000 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 11:49:00 AM | 3 | 3X3 | 5982109.291 | 2105604.0369 | 37.760550193841404 | -122.505003612665 | (37.7605501938414, -122.505003612665) | ||
| 177 | 177 | 97317 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:59:00 PM | 3 | 3x3 | 5990071.4812 | 2099073.5168 | 37.7430843422325 | -122.476989128346 | (37.7430843422325, -122.476989128346) | ||
| 179 | 179 | 182083 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1101 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:33:00 PM | 3 | Width 0ft | 5989775.2775 | 2098997.3719 | 37.742858080169505 | -122.47800774412599 | (37.7428580801695, -122.478007744126) | ||
| 330 | 330 | 114206 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1030 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2016 01:19:00 PM | 3 | 3x3 | 5989968.0933 | 2099069.2019 | 37.7430664963024 | -122.477346296714 | (37.7430664963024, -122.477346296714) | ||
| 1364 | 1364 | 251507 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1365 | 1365 | 251509 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1367 | 1367 | 36152 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | 4 | Permit Number 39237 | 5996489.9045 | 2114249.7041 | 37.7851245233187 | -122.455892946486 | (37.7851245233187, -122.455892946486) | |
| 1372 | 1372 | 251508 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1375 | 1375 | 251506 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1386 | 1386 | 183693 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.6569 | 2105897.5428 | 37.7614111825323 | -122.501783460946 | (37.7614111825323, -122.501783460946) | ||
| 1390 | 1390 | 183692 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983047.3598 | 2105912.7714 | 37.761453037237 | -122.501782156698 | (37.761453037237, -122.501782156698) | ||
| 1404 | 1404 | 183694 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983048.5312 | 2105875.9885 | 37.7613521106328 | -122.501775383852 | (37.7613521106328, -122.501775383852) | ||
| 1408 | 1408 | 183696 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983051.3079 | 2105837.6039 | 37.7612468805065 | -122.50176294055599 | (37.7612468805065, -122.501762940556) | ||
| 1417 | 1417 | 183690 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983045.4855 | 2105953.0685 | 37.7615635715471 | -122.50179162058001 | (37.7615635715471, -122.50179162058) | ||
| 1419 | 1419 | 183699 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983053.3747 | 2105791.1008 | 37.761119317578505 | -122.501752351825 | (37.7611193175785, -122.501752351825) | ||
| 1428 | 1428 | 183691 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.4226 | 2105931.5142 | 37.76150444459871 | -122.50178678479799 | (37.7615044445987, -122.501786784798) | ||
| 1430 | 1430 | 183687 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 33196 | 5983043.3769 | 2106010.2341 | 37.7617204082059 | -122.50180314292801 | (37.7617204082059, -122.501803142928) | |
| 1835 | 1835 | 251742 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 300 Naylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002771.0 | 2086560.0 | 37.7094535905361 | -122.432184185389 | (37.7094535905361, -122.432184185389) | ||||
| 1836 | 1836 | 251749 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 601 Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002875.0 | 2087693.0 | 37.7125704580966 | -122.43190559156 | (37.7125704580966, -122.43190559156) | |||||
| 1848 | 1848 | 251743 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 143 Cordova St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001773.0 | 2087479.0 | 37.7119203272299 | -122.43569914014999 | (37.7119203272299, -122.43569914015) | |||||
| 2004 | 2004 | 836 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1396X 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2017 10:52:00 AM | 3 | 3X3 | 5981241.3128 | 2105622.3145 | 37.7605492737866 | -122.50800685617901 | (37.7605492737866, -122.508006856179) | ||
| 2122 | 2122 | 252898 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 501x Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997879.0 | 2089997.0 | 37.7186122227881 | -122.44933914222901 | (37.7186122227881, -122.449339142229) | ||||
| 2369 | 2369 | 201815 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021129.2467 | 2093308.19399 | 37.7290066829092 | -122.369200102111 | (37.7290066829092, -122.369200102111) | ||
| 2381 | 2381 | 201818 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 2 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021088.08179 | 2093322.4173400002 | 37.7290434795636 | -122.369343396492 | (37.7290434795636, -122.369343396492) | ||
| 2383 | 2383 | 201821 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021045.51426 | 2093266.4470799998 | 37.7288874606638 | -122.369486691782 | (37.7288874606638, -122.369486691782) | ||
| 2387 | 2387 | 201822 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021035.49669 | 2093250.0299200001 | 37.72884183267921 | -122.36952018972299 | (37.7288418326792, -122.369520189723) | ||
| 2390 | 2390 | 201832 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020752.62591 | 2092874.74971 | 37.727795861786205 | -122.370472171548 | (37.7277958617862, -122.370472171548) | |
| 2391 | 2391 | 201814 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021112.10587 | 2093285.4865 | 37.728943392223 | -122.36925779181699 | (37.728943392223, -122.369257791817) | ||
| 2400 | 2400 | 201838 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020663.4716 | 2092744.71005 | 37.7274339035298 | -122.37077139578501 | (37.7274339035298, -122.370771395785) | |
| 2405 | 2405 | 201816 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021143.08428 | 2093327.21502 | 37.729059670062206 | -122.36915357747299 | (37.7290596700622, -122.369153577473) | ||
| 2406 | 2406 | 201829 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 284 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020846.41585 | 2093000.7945400001 | 37.7281471046068 | -122.37015664263399 | (37.7281471046068, -122.370156642634) | |
| 2408 | 2408 | 201820 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021056.53291 | 2093279.09213 | 37.728922786051506 | -122.369449472416 | (37.7289227860515, -122.369449472416) | ||
| 2409 | 2409 | 201824 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 8 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021004.603680001 | 2093212.5880900002 | 37.728737329640495 | -122.369624404053 | (37.7287373296405, -122.369624404053) | ||
| 2410 | 2410 | 201817 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021101.98762 | 2093338.62944 | 37.7290887577236 | -122.36929644199101 | (37.7290887577236, -122.369296441991) | ||
| 2411 | 2411 | 201831 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020768.36275 | 2092897.8842900002 | 37.7278602487283 | -122.37041936696698 | (37.7278602487283, -122.370419366967) | |
| 2417 | 2417 | 201819 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021071.50009 | 2093300.7706900002 | 37.7289831323462 | -122.369399226393 | (37.7289831323462, -122.369399226393) | ||
| 2419 | 2419 | 201835 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020706.7385 | 2092807.85492 | 37.72760966254629 | -122.370626184075 | (37.7276096625463, -122.370626184075) | |
| 2423 | 2423 | 201830 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 292 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020827.60649 | 2092975.44043 | 37.7280764547545 | -122.370219916224 | (37.7280764547545, -122.370219916224) | |
| 2435 | 2435 | 201826 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 250 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020898.42083 | 2093071.04954 | 37.7283428654122 | -122.369981710984 | (37.7283428654122, -122.369981710984) | |
| 2438 | 2438 | 201823 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 7 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021023.85438 | 2093233.10906 | 37.728794732485206 | -122.369559269737 | (37.7287947324852, -122.369559269737) | ||
| 2444 | 2444 | 201828 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 268 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020862.97624 | 2093021.3694799999 | 37.728204508308 | -122.3701008136 | (37.728204508308, -122.3701008136) | |
| 2446 | 2446 | 201827 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 258 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020879.65439 | 2093047.83852 | 37.7282781025329 | -122.370044984594 | (37.7282781025329, -122.370044984594) | |
| 2452 | 2452 | 201837 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020676.58787 | 2092764.09442 | 37.7274878493838 | -122.370727391967 | (37.7274878493838, -122.370727391967) | |
| 2453 | 2453 | 201836 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020688.4191 | 2092782.87071 | 37.7275400550072 | -122.370687788509 | (37.7275400550072, -122.370687788509) | |
| 2454 | 2454 | 201833 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020733.63229 | 2092847.8779900002 | 37.727721034575296 | -122.370535976659 | (37.7277210345753, -122.370535976659) | |
| 2460 | 2460 | 201825 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 232 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020928.29141 | 2093111.1924700001 | 37.7284547293849 | -122.36988121894899 | (37.7284547293849, -122.369881218949) | |
| 2461 | 2461 | 201834 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020718.56969 | 2092826.63123 | 37.7276618681873 | -122.37058658062 | (37.7276618681873, -122.37058658062) | |
| 2466 | 2466 | 201813 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021086.18405 | 2093254.37787 | 37.728856551886395 | -122.369345258092 | (37.7288565518864, -122.369345258092) | ||
| 2643 | 2643 | 37817 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 450X Moscow St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003961.27408 | 2090526.1025099999 | 37.7204110616965 | -122.428352887393 | (37.7204110616965, -122.428352887393) |
| 2664 | 2664 | 37831 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 450X Moscow St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003870.23097 | 2090403.3538799998 | 37.720068868758105 | -122.42865884842699 | (37.7200688687581, -122.428658848427) |
| 2667 | 2667 | 37820 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 450X Moscow St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003945.80086 | 2090498.97809 | 37.7203357084188 | -122.428404441018 | (37.7203357084188, -122.428404441018) |
| 2676 | 2676 | 253162 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 323 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004481.0 | 2091226.0 | 37.7223622223708 | -122.42660617515699 | (37.7223622223708, -122.426606175157) | ||||
| 3788 | 3788 | 118108 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3585 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2017 12:00:00 AM | 3 | Width 3ft | 5984519.42575 | 2111051.46948 | 37.7756488017479 | -122.497070281467 | (37.7756488017479, -122.497070281467) | ||
| 3913 | 3913 | 253116 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 12:00:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3915 | 3915 | 160069 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:26:00 AM | 3 | Width 0ft | 6000296.79811 | 2090527.7878900003 | 37.7202076512361 | -122.441019880684 | (37.7202076512361, -122.441019880684) | ||
| 3918 | 3918 | 253108 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:41:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3922 | 3922 | 160059 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 10:50:00 AM | 3 | Width 0ft | 6000588.557440001 | 2091082.6412900002 | 37.7217477663201 | -122.440051133668 | (37.7217477663201, -122.440051133668) | ||
| 3928 | 3928 | 253114 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:55:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3934 | 3934 | 160071 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:31:00 AM | 3 | Width 0ft | 6000209.4859 | 2090450.10808 | 37.7199893866688 | -122.44131611827 | (37.7199893866688, -122.44131611827) | ||
| 3935 | 3935 | 160073 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:36:00 AM | 3 | Width 0ft | 6000082.999340001 | 2090399.7386 | 37.7198438772755 | -122.44174972458201 | (37.7198438772755, -122.441749724582) | ||
| 3937 | 3937 | 253112 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:51:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3939 | 3939 | 160065 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:13:00 AM | 3 | Width 0ft | 6000417.53141 | 2090750.6791299998 | 37.7208265358932 | -122.440618525839 | (37.7208265358932, -122.440618525839) | ||
| 3946 | 3946 | 160063 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:07:00 AM | 3 | Width 0ft | 6000471.59074 | 2090857.9533099998 | 37.7211241647202 | -122.440439349407 | (37.7211241647202, -122.440439349407) | ||
| 3950 | 3950 | 162332 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 36 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:06:00 PM | 3 | Width 0ft | 5996526.7373 | 2090117.21242 | 37.718864853708205 | -122.45402201441001 | (37.7188648537082, -122.45402201441) | ||
| 3960 | 3960 | 160061 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:02:00 AM | 3 | Width 0ft | 6000547.454419999 | 2091000.21878 | 37.7215191128017 | -122.440187308101 | (37.7215191128017, -122.440187308101) | ||
| 3968 | 3968 | 253118 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 01:35:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3971 | 3971 | 251681 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:36:00 PM | 3 | 3x5 | 5996550.0 | 2089909.0 | 37.7182944850221 | -122.453926576307 | (37.7182944850221, -122.453926576307) | ||
| 3973 | 3973 | 253110 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:46:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3974 | 3974 | 162331 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 26 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:09:00 PM | 3 | Width 0ft | 5996526.61739 | 2090076.5104099999 | 37.7187530886569 | -122.454019490912 | (37.7187530886569, -122.454019490912) | ||
| 3982 | 3982 | 159338 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 517 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:04:00 AM | 3 | Width 0ft | 5998112.9338 | 2087183.20699 | 37.7108995709325 | -122.44832801714199 | (37.7108995709325, -122.448328017142) | ||
| 3992 | 3992 | 159336 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 523 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:36:00 AM | 3 | Width 0ft | 5998080.57171 | 2087152.95418 | 37.7108146533454 | -122.448437690352 | (37.7108146533454, -122.448437690352) | ||
| 4007 | 4007 | 216655 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 161 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:49:00 PM | 3 | Width 3ft | 5995318.74701 | 2090961.5845400002 | 37.7211139601174 | -122.45825861266 | (37.7211139601174, -122.45825861266) | ||
| 4058 | 4058 | 159346 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 461 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:49:00 AM | 3 | Width 0ft | 5998276.6806 | 2087336.8062099998 | 37.7113306798385 | -122.44777312285 | (37.7113306798385, -122.44777312285) | ||
| 4070 | 4070 | 159339 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 517 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:12:00 AM | 3 | Width 0ft | 5998126.4578599995 | 2087195.02696 | 37.710932799068104 | -122.44828212563 | (37.7109327990681, -122.44828212563) | ||
| 4072 | 4072 | 159348 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 461 Ellington Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:44:00 AM | 3 | Width 0ft | 5998312.68186 | 2087372.3667799998 | 37.711430378688796 | -122.447651252104 | (37.7114303786888, -122.447651252104) | ||
| 4077 | 4077 | 159345 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 461 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:39:00 AM | 3 | Width 0ft | 5998268.07471 | 2087327.6085 | 37.7113049331395 | -122.447802205131 | (37.7113049331395, -122.447802205131) | ||
| 4091 | 4091 | 159347 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 461 Ellington Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:27:00 AM | 3 | Width 0ft | 5998288.37354 | 2087349.92963 | 37.711367382076396 | -122.44773365338999 | (37.7113673820764, -122.44773365339) | ||
| 4096 | 4096 | 181028 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 95 Rolph St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 04:38:00 PM | 3 | Width 4ft | 6000533.08885 | 2088674.4676599998 | 37.715132307492794 | -122.44007027934201 | (37.7151323074928, -122.440070279342) | ||
| 4113 | 4113 | 181027 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 95 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 04:23:00 PM | 3 | Width 4ft | 6000546.58685 | 2088667.2481099998 | 37.7151132526545 | -122.440023107188 | (37.7151132526545, -122.440023107188) | ||
| 4127 | 4127 | 207021 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 400 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 07:38:00 AM | 3 | Width 3ft | 5995575.229619999 | 2090581.47857 | 37.720085014301894 | -122.457344548018 | (37.7200850143019, -122.457344548018) | ||
| 4130 | 4130 | 216848 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 258 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 02:39:00 PM | 3 | Width 3ft | 5994378.76562 | 2088424.12647 | 37.7140926462446 | -122.461323980613 | (37.7140926462446, -122.461323980613) | ||
| 4142 | 4142 | 216723 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 08:05:00 AM | 3 | Width 2ft | 5995305.86266 | 2090248.9874099998 | 37.7191565973781 | -122.458251599737 | (37.7191565973781, -122.458251599737) | ||
| 4192 | 4192 | 216845 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 194 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 07:48:00 AM | 3 | Width 3ft | 5995118.95449 | 2088413.12295 | 37.714105005620205 | -122.458764825742 | (37.7141050056202, -122.458764825742) | ||
| 4220 | 4220 | 181020 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 183 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 12:41:00 PM | 3 | Width 4ft | 6000952.49174 | 2088426.9301099998 | 37.714476492181895 | -122.438602919392 | (37.7144764921819, -122.438602919392) | ||
| 4227 | 4227 | 181017 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 197 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 11:28:00 AM | 3 | Width 4ft | 6001019.31887 | 2088386.79799 | 37.7143700996689 | -122.43836906510201 | (37.7143700996689, -122.438369065102) | ||
| 4245 | 4245 | 181019 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 191 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 12:36:00 PM | 3 | Width 4ft | 6000981.45407 | 2088409.26942 | 37.714429647391896 | -122.438501549606 | (37.7144296473919, -122.438501549606) | ||
| 4257 | 4257 | 181010 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 215 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 11:17:00 AM | 3 | Width 4ft | 6001139.6561 | 2088316.9005900002 | 37.7141850209845 | -122.437948129327 | (37.7141850209845, -122.437948129327) | ||
| 4258 | 4258 | 19062 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 174 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2017 08:47:00 AM | 3 | 3X3 | 5995225.08055 | 2087462.80286 | 37.7115017488702 | -122.458329272374 | (37.7115017488702, -122.458329272374) | ||
| 4266 | 4266 | 181021 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 179 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 12:49:00 PM | 3 | 8x6 | 6000934.6994199995 | 2088437.13017 | 37.71450348711 | -122.438665147076 | (37.71450348711, -122.438665147076) | ||
| 4270 | 4270 | 252889 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 301x Howth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:58:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4273 | 4273 | 181018 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 197 Rolph St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 11:31:00 AM | 3 | Width 4ft | 6001005.57228 | 2088396.0469099998 | 37.714394713229105 | -122.43841724088999 | (37.7143947132291, -122.43841724089) |
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");