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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33605 | 33605 | 227093 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 31 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 9ft | 6009184.481319999 | 2095791.0539799999 | 37.7351616771725 | -122.41066949551201 | (37.7351616771725, -122.410669495512) | |||
| 171469 | 171469 | 227092 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 9ft | 6009197.49082 | 2095788.0482299998 | 37.7351541534232 | -122.410624304588 | (37.7351541534232, -122.410624304588) | |||
| 28135 | 28135 | 41812 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100 Anzavista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999993.4162 | 2112171.4558 | 37.7796186440476 | -122.44362258073 | (37.7796186440476, -122.44362258073) | |
| 41560 | 41560 | 41808 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100 Anzavista Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999945.6987 | 2112165.7027 | 37.7796001259133 | -122.44378724216601 | (37.7796001259133, -122.443787242166) | |
| 71350 | 71350 | 41807 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100 Anzavista Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999913.2102 | 2112161.3032 | 37.7795861928813 | -122.443899317319 | (37.7795861928813, -122.443899317319) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 30642 | 30642 | 176917 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6001514.03799 | 2088123.65893 | 37.7136757052349 | -122.436640299224 | (37.7136757052349, -122.436640299224) | ||||
| 44260 | 44260 | 116540 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001555.506159999 | 2088195.95431 | 37.713876568835396 | -122.43650214175399 | (37.7138765688354, -122.436502141754) | |||
| 156295 | 156295 | 116548 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001544.87474 | 2088178.1549900002 | 37.713827091712396 | -122.436537614614 | (37.7138270917124, -122.436537614614) | |||
| 158635 | 158635 | 116539 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001567.487380001 | 2088213.7256900002 | 37.7139260459311 | -122.436462001442 | (37.7139260459311, -122.436462001442) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 24383 | 24383 | 116552 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001598.03525 | 2088202.06693 | 37.7138957693564 | -122.436355582838 | (37.7138957693564, -122.436355582838) | |||
| 146422 | 146422 | 116546 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001545.434780001 | 2088113.86518 | 37.7136505979649 | -122.43653108014401 | (37.7136505979649, -122.436531080144) | |||
| 27395 | 27395 | 227153 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 105 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008266.03922 | 2099383.96222 | 37.7449754768472 | -122.41409899629299 | (37.7449754768472, -122.414098996293) | |||
| 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) | ||
| 10990 | 10990 | 109578 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 10X Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775018 | 6002262.55573 | 2092599.72242 | 37.72600848708289 | -122.434372977031 | (37.7260084870829, -122.434372977031) |
| 12537 | 12537 | 109577 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 10X Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775018 | 6002290.3134 | 2092582.02308 | 37.72596146424 | -122.434275755847 | (37.72596146424, -122.434275755847) |
| 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) | ||
| 162744 | 162744 | 37654 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1108 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51611 | 5992123.06102 | 2110701.1817099997 | 37.775129656063 | -122.47074215707899 | (37.775129656063, -122.470742157079) | |
| 12102 | 12102 | 27527 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1114 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/03/2015 07:52:00 AM | 3 | 3X3 | 6008222.66754 | 2093785.3034 | 37.729600346979794 | -122.41385300921101 | (37.7296003469798, -122.413853009211) | ||
| 134106 | 134106 | 94712 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 119 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53849 | 5993940.39408 | 2114713.66519 | 37.7862517797866 | -122.46474709013 | (37.7862517797866, -122.46474709013) |
| 22968 | 22968 | 115802 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1218 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 774518 | 5981226.5 | 2106751.9 | 37.7636499175412 | -122.50814192748999 | (37.7636499175412, -122.50814192749) | ||
| 153529 | 153529 | 183672 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1254 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5984312.3195 | 2106638.1262 | 37.7635188796404 | -122.497460805156 | (37.7635188796404, -122.497460805156) | |||
| 64011 | 64011 | 176891 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 128 Craut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004014.42285 | 2094241.1944400002 | 37.730614887467205 | -122.428433829062 | (37.7306148874672, -122.428433829062) | |||
| 152401 | 152401 | 176892 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 128 Craut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004016.19178 | 2094155.9191400001 | 37.7303808407035 | -122.428421637873 | (37.7303808407035, -122.428421637873) | |||
| 12859 | 12859 | 27036 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1328 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2005 12:00:00 AM | 3 | 3X3 | 6009383.50137 | 2094296.42093 | 37.7310688913025 | -122.409875935553 | (37.7310688913025, -122.409875935553) | ||
| 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) | |
| 10726 | 10726 | 26985 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1353 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2009 12:00:00 AM | 3 | 3X3 | 6009441.55287 | 2094364.79553 | 37.731259886623896 | -122.409680064978 | (37.7312598866239, -122.409680064978) | ||
| 141295 | 141295 | 59241 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 138 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | Permit Number 18570 | 5998056.20401336 | 2105984.36092392 | 37.762519790788396 | -122.449878183328 | (37.7625197907884, -122.449878183328) | ||
| 103181 | 103181 | 27003 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1380X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2009 12:00:00 AM | 3 | 3X3 | 6009629.1666 | 2094382.2025400002 | 37.7313181942464 | -122.409032675373 | (37.7313181942464, -122.409032675373) | ||
| 128401 | 128401 | 27026 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1380X Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2005 12:00:00 AM | 3 | 3X3 | 6009629.1666 | 2094382.2025400002 | 37.7313181942464 | -122.409032675373 | (37.7313181942464, -122.409032675373) | ||
| 22862 | 22862 | 176910 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1390 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009561.38521 | 2094361.93193 | 37.7312587382014 | -122.409265579153 | (37.7312587382014, -122.409265579153) | |||
| 22870 | 22870 | 176911 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1390 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009574.07755 | 2094366.6897 | 37.731272513113296 | -122.409222034865 | (37.7312725131133, -122.409222034865) | |||
| 22875 | 22875 | 176912 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1390 Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009589.47798 | 2094371.19963 | 37.7312857592085 | -122.409169110679 | (37.7312857592085, -122.409169110679) | |||
| 22876 | 22876 | 176913 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1390 Silver Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009673.25426 | 2094402.8730900001 | 37.7313774208194 | -122.40888171341999 | (37.7313774208194, -122.40888171342) | |||
| 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) | ||
| 10655 | 10655 | 26983 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1395 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2009 12:00:00 AM | 3 | 3X3 | 6009622.935740001 | 2094432.5688200002 | 37.731456140283704 | -122.409057769215 | (37.7314561402837, -122.409057769215) | ||
| 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) | ||
| 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) | ||
| 13263 | 13263 | 835 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1396X 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2017 10:55:00 AM | 3 | 3X3 | 5981242.3727 | 2105595.8151 | 37.7604765764936 | -122.5080012238 | (37.7604765764936, -122.5080012238) | ||
| 65576 | 65576 | 176919 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 140 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6001505.61042 | 2087336.29034 | 37.71151328628479 | -122.436613103724 | (37.7115132862848, -122.436613103724) | |||
| 10385 | 10385 | 93406 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1408 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/24/2015 11:15:00 AM | 3 | 3x3 | 5988828.0589 | 2099030.2661 | 37.7428933746541 | -122.48128533094 | (37.7428933746541, -122.48128533094) | ||
| 84495 | 84495 | 840 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1412 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2015 01:14:00 PM | 3 | 3x3 | 5981250.420684201 | 2105445.3666042998 | 37.7600639622975 | -122.507962224252 | (37.7600639622975, -122.507962224252) | ||
| 11177 | 11177 | 93407 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1414 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/24/2015 11:09:00 AM | 3 | 3x3 | 5988810.4689 | 2099030.2661 | 37.74289235198079 | -122.48134615155399 | (37.7428923519808, -122.481346151554) | ||
| 10532 | 10532 | 27006 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1420 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/13/1999 12:00:00 AM | 3 | 3X3 | 6009885.433069999 | 2094479.90043 | 37.73160080432 | -122.408153598922 | (37.73160080432, -122.408153598922) | ||
| 12392 | 12392 | 27007 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1424 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1999 12:00:00 AM | 3 | 3X3 | 6009909.30958 | 2094487.23688 | 37.731622285542706 | -122.408071569962 | (37.7316222855427, -122.408071569962) | ||
| 12324 | 12324 | 27008 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1430 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1999 12:00:00 AM | 3 | 3X3 | 6009940.18408 | 2094497.7501400001 | 37.731652881356396 | -122.407965571349 | (37.7316528813564, -122.407965571349) | ||
| 122176 | 122176 | 109275 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1437 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773660 | 5984291.9 | 2105367.5 | 37.7600289003771 | -122.4974376175 | (37.7600289003771, -122.4974376175) |
| 11601 | 11601 | 27009 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1446 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 3 | 3X3 | 6010020.23018 | 2094527.09535 | 37.731737938333104 | -122.40769090313299 | (37.7317379383331, -122.407690903133) | ||
| 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) | |
| 162586 | 162586 | 183640 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1484 47th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5981572.1323 | 2104991.2828 | 37.7588361283195 | -122.506815916291 | (37.7588361283195, -122.506815916291) | |||
| 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) | |
| 152533 | 152533 | 51411 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1578 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51340 | 5989038.1128 | 2104597.9638 | 37.7581930050331 | -122.48096659569299 | (37.7581930050331, -122.480966595693) | |
| 37096 | 37096 | 207011 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 16 Circular Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001351.22893 | 2094512.68179 | 37.731209264673296 | -122.437660309391 | (37.7312092646733, -122.437660309391) | |||
| 135130 | 135130 | 207012 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 16 Circular Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001339.26796 | 2094505.8060299999 | 37.731189705325 | -122.43770116826799 | (37.731189705325, -122.437701168268) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 134827 | 134827 | 206996 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1607 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993365.5475 | 2104527.17443 | 37.758249235518605 | -122.465995428957 | (37.7582492355186, -122.465995428957) | |||
| 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) |
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");