Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus ▲ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
115634 | 115634 | 90743 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4429 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981841.9267 | 2110274.36208 | 37.773357823390896 | -122.50627461209801 | (37.7733578233909, -122.506274612098) | ||
115973 | 115973 | 27273 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2095X Silver Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2011 12:00:00 AM | 8 | 3X3 | 6012407.8106259005 | 2096047.4553772 | 37.736045896585495 | -122.399543203223 | (37.7360458965855, -122.399543203223) | ||
116902 | 116902 | 90719 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4616 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981255.7970900005 | 2110310.22456 | 37.7734217675099 | -122.50830474267099 | (37.7734217675099, -122.508304742671) | ||
118655 | 118655 | 90283 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4508 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981566.01243 | 2111001.7560900003 | 37.7753387866897 | -122.507282997083 | (37.7753387866897, -122.507282997083) | ||
118920 | 118920 | 113357 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 POINT LOBOS AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 5982777.0 | 2112621.0 | 37.779856011140204 | -122.50321389449499 | (37.7798560111402, -122.503213894495) | ||||
119386 | 119386 | 24739 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2004 12:00:00 AM | 3 | 3X3 | 5982782.27657 | 2112574.64249 | 37.7797290371816 | -122.503192207591 | (37.7797290371816, -122.503192207591) | ||
119389 | 119389 | 24747 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 200X Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/09/1999 12:00:00 AM | 3 | 3X3 | 5982215.35166 | 2112638.47493 | 37.779870961567894 | -122.505158146759 | (37.7798709615679, -122.505158146759) | ||
120493 | 120493 | 90705 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4320 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982162.77985 | 2110342.56704 | 37.773563978190495 | -122.505169810987 | (37.7735639781905, -122.505169810987) | ||
121651 | 121651 | 112021 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2101x 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761.0 | 2103726.0 | 37.757093449930004 | -122.402319220858 | (37.75709344993, -122.402319220858) | ||
122641 | 122641 | 98557 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 3906 Judah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/07/2012 12:00:00 AM | 3 | 5982438.0 | 2105598.0 | 37.7605529521075 | -122.50386633030199 | (37.7605529521075, -122.503866330302) | |||
125110 | 125110 | 90275 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4300X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982191.02218 | 2111027.01163 | 37.775444924896 | -122.50512285244801 | (37.775444924896, -122.505122852448) | ||
126331 | 126331 | 90735 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4519 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981584.56948 | 2110265.78848 | 37.7733191284439 | -122.507164194881 | (37.7733191284439, -122.507164194881) | ||
140064 | 140064 | 90742 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4435 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981815.15401 | 2110273.6149 | 37.773354195669704 | -122.506367165545 | (37.7733541956697, -122.506367165545) | ||
140280 | 140280 | 112025 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2101x 22nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761.0 | 2103726.0 | 37.757093449930004 | -122.402319220858 | (37.75709344993, -122.402319220858) | ||
142042 | 142042 | 90740 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4451X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981760.6962 | 2110270.81896 | 37.77334331252779 | -122.506555332031 | (37.7733433125278, -122.506555332031) | ||
144716 | 144716 | 90746 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4345 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982095.14058 | 2110285.66939 | 37.7734037737787 | -122.50539956320499 | (37.7734037737787, -122.505399563205) | ||
145023 | 145023 | 27161 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1700X Silver Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 6011020.5092245005 | 2095004.7366116 | 37.733105385033795 | -122.40426632243 | (37.7331053850338, -122.40426632243) | ||
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) | |||
151872 | 151872 | 116550 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 3x3 | 6001534.78323 | 2088160.3445099997 | 37.7137776146169 | -122.43657122050399 | (37.7137776146169, -122.436571220504) | |||
152469 | 152469 | 113356 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 Point Lobos Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3X3 | 5982735.90689 | 2112577.0088400003 | 37.7797328087219 | -122.503352793138 | (37.7797328087219, -122.503352793138) | |||
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) | |||
157761 | 157761 | 116545 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 3x3 | 6001537.057630001 | 2088100.5912 | 37.7136136745151 | -122.436559085032 | (37.7136136745151, -122.436559085032) | |||
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) | |||
158984 | 158984 | 116549 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 3x3 | 6001562.82912 | 2088145.2407900002 | 37.713737736870705 | -122.43647320339599 | (37.7137377368707, -122.436473203396) | |||
171144 | 171144 | 176918 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6001604.803669999 | 2088215.9120200002 | 37.713934169489704 | -122.43633317895599 | (37.7139341694897, -122.436333178956) | ||||
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) | ||||
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) | ||||
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) | |||||
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) | ||||
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) | ||
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) | ||
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) | ||
4276 | 4276 | 180842 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 87 Laura St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:54:00 PM | 3 | Width 2ft | 5997291.8877 | 2087045.22216 | 37.710473721248 | -122.45115578601299 | (37.710473721248, -122.451155786013) | ||
4282 | 4282 | 251444 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 244 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 07:40:00 AM | 3 | 3x3 | 5994545.0 | 2088436.0 | 37.7141348140673 | -122.460750275072 | (37.7141348140673, -122.460750275072) | ||
4306 | 4306 | 181011 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 207 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 11:21:00 AM | 3 | Width 4ft | 6001121.315830001 | 2088326.0025400002 | 37.714208969932706 | -122.438012171843 | (37.7142089699327, -122.438012171843) | ||
4375 | 4375 | 176488 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 295 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 09:25:00 AM | 3 | Width 2ft | 6004452.7164199995 | 2090718.28415 | 37.7209665468512 | -122.4266678079 | (37.7209665468512, -122.4266678079) | ||
4432 | 4432 | 172375 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 216 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 07:37:00 AM | 3 | Width 2ft | 6002574.0 | 2086750.0 | 37.7099641176609 | -122.432878614235 | (37.7099641176609, -122.432878614235) | ||
4451 | 4451 | 216718 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 978 Capitol Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/13/2017 11:36:00 AM | 3 | Width 3ft | 5995057.03199 | 2090421.24862 | 37.7196152839906 | -122.45912417326299 | (37.7196152839906, -122.459124173263) | ||
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) | |||
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) | |||
24647 | 24647 | 227111 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008285.63801 | 2099411.47629 | 37.745052125166296 | -122.414033173096 | (37.7450521251663, -122.414033173096) | |||
24713 | 24713 | 71549 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 780 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772812 | 6008431.05429 | 2114892.38013 | 37.7875672592553 | -122.41462566084101 | (37.7875672592553, -122.414625660841) |
25321 | 25321 | 227575 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 33 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001460.70601 | 2108045.90078 | 37.7683744785129 | -122.43825097062 | (37.7683744785129, -122.43825097062) | |||
25454 | 25454 | 227130 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5999573.3022300005 | 2100550.7346900003 | 37.747687072210105 | -122.44424063169599 | (37.7476870722101, -122.444240631696) | |||
25567 | 25567 | 227123 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 483 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002011.92527 | 2100876.5046200003 | 37.748720385135705 | -122.43583132576201 | (37.7487203851357, -122.435831325762) | |||
25668 | 25668 | 118581 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 104 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982478.43556 | 2112606.9372400003 | 37.7797998443253 | -122.504245701476 | (37.7797998443253, -122.504245701476) | |||
25776 | 25776 | 227129 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 291 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001319.20971 | 2096463.3667400002 | 37.7365635736601 | -122.43791067344401 | (37.7365635736601, -122.437910673444) | |||
25925 | 25925 | 206997 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1290 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5992719.48539 | 2106665.14578 | 37.7640822509305 | -122.46838531523998 | (37.7640822509305, -122.46838531524) | |||
26337 | 26337 | 227551 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 571 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003034.11181 | 2104925.46753 | 37.75989588789739 | -122.432585790315 | (37.7598958878974, -122.432585790315) |
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");