Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 178920 | 178920 | 201812 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6021065.67541 | 2093224.76894 | 37.728774126326705 | -122.369414113788 | (37.7287741263267, -122.369414113788) | |||
| 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) | ||
| 64913 | 64913 | 201811 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6021050.71889 | 2093203.62599 | 37.7287152512926 | -122.369464359799 | (37.7287152512926, -122.369464359799) | |||
| 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) | ||
| 65062 | 65062 | 201810 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6021035.70856 | 2093179.8039900002 | 37.7286490171175 | -122.369514606714 | (37.7286490171175, -122.369514606714) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 157074 | 157074 | 201809 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 237 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6020945.51773 | 2093059.3003900002 | 37.72831318869729 | -122.369818081152 | (37.7283131886973, -122.369818081152) | |||
| 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) | |
| 50519 | 50519 | 201808 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 247 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6020927.8472 | 2093035.08257 | 37.7282457215548 | -122.369877496672 | (37.7282457215548, -122.369877496672) | |||
| 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) | |
| 179043 | 179043 | 201807 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 273 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 6ft | 6020893.117219999 | 2092989.08595 | 37.728117517799795 | -122.36999438334298 | (37.7281175177998, -122.369994383343) | |||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 5022 | 5022 | 3539 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 201X Cargo Way | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 08:08:00 AM | 3 | 3X3 | 6018487.88793 | 2097755.11327 | 37.741071817512704 | -122.378640230766 | (37.7410718175127, -122.378640230766) | ||
| 5006 | 5006 | 3538 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 201X Cargo Way | 48 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 10:28:00 AM | 3 | 3X3 | 6018470.22426 | 2097768.00954 | 37.741106254339705 | -122.37870220126999 | (37.7411062543397, -122.37870220127) | ||
| 4929 | 4929 | 3534 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 201X Cargo Way | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:10:00 AM | 3 | 3X3 | 6018402.129369999 | 2097818.41667 | 37.7412409080406 | -122.378941151133 | (37.7412409080406, -122.378941151133) | ||
| 4939 | 4939 | 3523 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 201X Cargo Way | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:28:00 AM | 3 | 3X3 | 6018216.35215 | 2097958.4950099997 | 37.741615290427106 | -122.379593238756 | (37.7416152904271, -122.379593238756) | ||
| 4963 | 4963 | 3516 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 201X Cargo Way | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/07/1996 12:00:00 AM | 6 | 3X3 | 6018109.71439 | 2098036.73671 | 37.7418242442879 | -122.379967395395 | (37.7418242442879, -122.379967395395) | ||
| 5034 | 5034 | 3513 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 201X Cargo Way | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:31:00 AM | 3 | 3X3 | 6018063.30501 | 2098072.0296400003 | 37.7419185912736 | -122.38013031748699 | (37.7419185912736, -122.380130317487) | ||
| 5012 | 5012 | 189150 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 351 Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:46:00 AM | 3 | Width 3ft | 6017356.8528 | 2098625.87133 | 37.7434003277556 | -122.382611554189 | (37.7434003277556, -122.382611554189) | ||
| 5071 | 5071 | 203010 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 351 Cargo Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:48:00 AM | 3 | Width 3ft | 6017339.6558 | 2098641.75454 | 37.743442989794005 | -122.38267212263399 | (37.743442989794, -122.382672122634) | ||
| 4944 | 4944 | 3666 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100X Cargo Way | 102 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/02/2017 03:06:00 PM | 3 | 3X3 | 6017134.48475 | 2098914.37607 | 37.744180216238604 | -122.383400533034 | (37.7441802162386, -122.383400533034) | ||
| 5053 | 5053 | 3667 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100X Cargo Way | 103 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/02/2017 03:19:00 PM | 3 | 3X3 | 6017116.62756 | 2098928.27448 | 37.744217391521396 | -122.38346324724199 | (37.7442173915214, -122.383463247242) | ||
| 4976 | 4976 | 3673 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100X Cargo Way | 109 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:21:00 AM | 3 | 3X3 | 6017015.17172 | 2099002.6203400004 | 37.7444159222737 | -122.38381923847601 | (37.7444159222737, -122.383819238476) | ||
| 4971 | 4971 | 3674 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100X Cargo Way | 110 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:22:00 AM | 3 | 3X3 | 6016998.30504 | 2099015.89853 | 37.7444514490906 | -122.383878484902 | (37.7444514490906, -122.383878484902) | ||
| 4933 | 4933 | 3676 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100X Cargo Way | 112 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:24:00 AM | 3 | 3X3 | 6016964.487509999 | 2099042.50937 | 37.74452264751721 | -122.38399727276101 | (37.7445226475172, -122.383997272761) | ||
| 4959 | 4959 | 3681 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100X Cargo Way | 117 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/02/2017 03:27:00 PM | 3 | 3X3 | 6016866.9573099995 | 2099120.49255 | 37.7447313810499 | -122.384339945926 | (37.7447313810499, -122.384339945926) | ||
| 171029 | 171029 | 191247 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1453 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6016461.47366 | 2096825.2224700002 | 37.7384066073881 | -122.385582111127 | (37.7384066073881, -122.385582111127) | |||
| 20660 | 20660 | 88463 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 955X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) |
| 94653 | 94653 | 88465 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 955X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) |
| 137533 | 137533 | 191229 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 901 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6015272.35005 | 2096832.51763 | 37.7383607716336 | -122.389694066038 | (37.7383607716336, -122.389694066038) | |||
| 49701 | 49701 | 191228 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 901 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6015254.00871 | 2096807.9147599998 | 37.7382922001146 | -122.38975576401 | (37.7382922001146, -122.38975576401) | |||
| 73450 | 73450 | 82700 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1506-1508 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52505 | 6015020.9353 | 2093436.9104 | 37.729023178313106 | -122.390326164865 | (37.7290231783131, -122.390326164865) | |
| 22360 | 22360 | 191245 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1675 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6014937.212180001 | 2097262.06336 | 37.7395216264201 | -122.3908828304 | (37.7395216264201, -122.3908828304) | |||
| 184622 | 184622 | 93188 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1675 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53196 | 6014934.44131 | 2097265.12572 | 37.73952988128521 | -122.39089262491001 | (37.7395298812852, -122.39089262491) | |
| 116014 | 116014 | 88480 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51432 | 6014837.0 | 2096254.0 | 37.7367481304458 | -122.391158879645 | (37.7367481304458, -122.391158879645) | ||
| 150165 | 150165 | 88483 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014835.95113 | 2096251.5284900002 | 37.7367412859786 | -122.39116233337201 | (37.7367412859786, -122.391162333372) | |
| 56854 | 56854 | 88482 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014826.8932300005 | 2096240.8429 | 37.7367114428676 | -122.391192904038 | (37.7367114428676, -122.391192904038) | |
| 39062 | 39062 | 88481 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014818.59944 | 2096228.0421 | 37.7366758342199 | -122.391220684988 | (37.7366758342199, -122.391220684988) | |
| 149498 | 149498 | 65594 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/1990 12:00:00 AM | 7 | Permit Number 28496 | 6014809.91986 | 2096215.04668 | 37.7366396697686 | -122.391249786165 | (37.7366396697686, -122.391249786165) | ||
| 75293 | 75293 | 95998 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1682 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767649 | 6014786.9 | 2096088.7 | 37.7362914700729 | -122.39132054683998 | (37.7362914700729, -122.39132054684) | |
| 107437 | 107437 | 95999 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1682 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767649 | 6014786.9 | 2096088.7 | 37.7362914700729 | -122.39132054683998 | (37.7362914700729, -122.39132054684) | |
| 49815 | 49815 | 191231 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1251 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014752.47592 | 2096139.2766099998 | 37.7364284325307 | -122.391443100815 | (37.7364284325307, -122.391443100815) | |||
| 29460 | 29460 | 191230 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1251 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014739.49892 | 2096121.8776900002 | 37.7363799383901 | -122.391486752132 | (37.7363799383901, -122.391486752132) | |||
| 13749 | 13749 | 68842 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 602 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 5 | 3x3 | Permit Number 767166 | 6014359.28345 | 2104329.14494 | 37.7588942535933 | -122.39337550020399 | (37.7588942535933, -122.393375500204) |
| 26796 | 26796 | 47678 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 536 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | 9 | Permit Number 45462 | 6014348.84456 | 2104603.39752 | 37.7596467118443 | -122.393430795897 | (37.7596467118443, -122.393430795897) | |
| 148658 | 148658 | 40072 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 102 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | 10 | Permit Number 41298 | 6014219.27435 | 2094112.15212 | 37.73083275450529 | -122.393144818701 | (37.7308327545053, -122.393144818701) | |
| 162953 | 162953 | 40073 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 102 Thornton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | 10 | Permit Number 41298 | 6014207.29735 | 2094114.30982 | 37.7308380137496 | -122.393186376362 | (37.7308380137496, -122.393186376362) | |
| 140085 | 140085 | 44279 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1588 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767652 | 6014189.45600011 | 2095460.4720273998 | 37.7345333093335 | -122.393342225003 | (37.7345333093335, -122.393342225003) | |
| 27087 | 27087 | 191234 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6014153.116769999 | 2095403.12134 | 37.734373817081796 | -122.39346385049299 | (37.7343738170818, -122.393463850493) | |||
| 41022 | 41022 | 191235 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014141.54444 | 2095385.83675 | 37.7343257141509 | -122.393502650848 | (37.7343257141509, -122.393502650848) | |||
| 35687 | 35687 | 191236 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014135.07988 | 2095376.9884099998 | 37.734301059229104 | -122.39352438203998 | (37.7343010592291, -122.39352438204) | |||
| 26506 | 26506 | 191237 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014127.4828 | 2095367.51286 | 37.7342746191851 | -122.39354998485001 | (37.7342746191851, -122.39354998485) | |||
| 53235 | 53235 | 191238 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6014118.19632 | 2095356.58877 | 37.734244107869294 | -122.393581327137 | (37.7342441078693, -122.393581327137) | |||
| 29298 | 29298 | 191239 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 9 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6014110.40607 | 2095343.3649799998 | 37.7342073651799 | -122.39360733551399 | (37.7342073651799, -122.393607335514) | |||
| 58507 | 58507 | 191240 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014102.75792 | 2095335.27393 | 37.734184723832996 | -122.393633211698 | (37.734184723833, -122.393633211698) | |||
| 50864 | 50864 | 191241 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014082.94285 | 2095307.88657 | 37.7341084226719 | -122.39369980292601 | (37.7341084226719, -122.393699802926) | |||
| 152707 | 152707 | 191242 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014072.32553 | 2095292.84785 | 37.734066539429996 | -122.39373545834299 | (37.73406653943, -122.393735458343) | |||
| 111070 | 111070 | 49802 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 MISSISSIPPI ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | Permit Number 46598 | 6014071.0 | 2106574.0 | 37.765042114519 | -122.39452971790399 | (37.765042114519, -122.394529717904) | ||
| 159032 | 159032 | 191243 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014061.56884 | 2095278.41625 | 37.734026315459104 | -122.39377163804899 | (37.7340263154591, -122.393771638049) | |||
| 72347 | 72347 | 191244 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014050.660540001 | 2095263.98772 | 37.733986091481206 | -122.39380834209801 | (37.7339860914812, -122.393808342098) | |||
| 55777 | 55777 | 49803 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 8 | Permit Number 46598 | 6014016.82872 | 2106570.58674 | 37.7650297307661 | -122.394716845308 | (37.7650297307661, -122.394716845308) | |
| 123811 | 123811 | 191221 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Mississippi St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014015.897890001 | 2106592.9178299997 | 37.7650909952748 | -122.39472162882099 | (37.7650909952748, -122.394721628821) | |||
| 179235 | 179235 | 191222 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1143 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013778.5148599995 | 2106149.81223 | 37.76386112381729 | -122.39551163825001 | (37.7638611238173, -122.39551163825) | |||
| 45140 | 45140 | 191227 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 201 Texas St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013759.687999999 | 2106121.42545 | 37.763782132758706 | -122.39557476618201 | (37.7637821327587, -122.395574766182) | |||
| 95133 | 95133 | 105013 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 330 Townsend St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6013709.8 | 2110877.9 | 37.7768395752266 | -122.396080672132 | (37.7768395752266, -122.396080672132) | ||||
| 96133 | 96133 | 105012 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 330 Townsend St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6013709.8 | 2110877.9 | 37.7768395752266 | -122.396080672132 | (37.7768395752266, -122.396080672132) | ||||
| 111186 | 111186 | 105014 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 330 Townsend St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6013709.8 | 2110877.9 | 37.7768395752266 | -122.396080672132 | (37.7768395752266, -122.396080672132) | ||||
| 129114 | 129114 | 88495 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 27 Reddy St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51437 | 6013659.0 | 2094063.0 | 37.7306666521666 | -122.39507835000201 | (37.7306666521666, -122.395078350002) | |||
| 186108 | 186108 | 176878 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6013154.94381 | 2086496.55313 | 37.709862662502104 | -122.396290845073 | (37.7098626625021, -122.396290845073) | |||
| 31319 | 31319 | 176877 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013098.43993 | 2086515.08302 | 37.709910397621705 | -122.396487432357 | (37.7099103976217, -122.396487432357) | |||
| 150547 | 150547 | 200836 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6013076.6871 | 2107039.6693 | 37.766265411985295 | -122.398001493496 | (37.7662654119853, -122.398001493496) | |||
| 140964 | 140964 | 108825 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 146-150X Gillette Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6013072.89275 | 2086799.9167400002 | 37.7106910734067 | -122.39659568235001 | (37.7106910734067, -122.39659568235) | |
| 51569 | 51569 | 200835 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6013058.6169 | 2107038.7182 | 37.7662617940431 | -122.398063928568 | (37.7662617940431, -122.398063928568) | |||
| 68994 | 68994 | 83834 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2300X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/04/2005 12:00:00 AM | 7 | 6013045.53048 | 2096356.5558 | 37.736930148098295 | -122.397360003177 | (37.7369301480983, -122.397360003177) | ||
| 55448 | 55448 | 60297 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/1998 12:00:00 AM | 7 | Permit Number 19862 | 6013032.9382 | 2107035.865 | 37.7662525295396 | -122.39815254670201 | (37.7662525295396, -122.398152546702) | |
| 146826 | 146826 | 176876 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013031.567530001 | 2086536.06642 | 37.7099642921874 | -122.396720027609 | (37.7099642921874, -122.396720027609) | |||
| 69248 | 69248 | 39552 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 10 | Permit Number 40979 | 6013009.1617 | 2107035.865 | 37.7662512051775 | -122.39823478562401 | (37.7662512051775, -122.398234785624) | ||
| 53294 | 53294 | 79640 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 168 Orsi Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 9 | 6012982.50067 | 2092948.34875 | 37.727568405236 | -122.397338990501 | (37.727568405236, -122.397338990501) | ||
| 107833 | 107833 | 87640 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2300X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 3x3 | 6012975.96285 | 2096322.27153 | 37.7368321371284 | -122.397598127165 | (37.7368321371284, -122.397598127165) | |||
| 13144 | 13144 | 108829 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 545 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6012931.90275 | 2086607.7470099998 | 37.7101555653976 | -122.397069513169 | (37.7101555653976, -122.397069513169) |
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");