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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 33343 | 33343 | 227094 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 35 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6009153.630890001 | 2095762.56962 | 37.7350817355269 | -122.410774146024 | (37.7350817355269, -122.410774146024) | ||||
| 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) | ||
| 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) | |||
| 171127 | 171127 | 227091 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 29 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6009293.034440001 | 2095834.7354700002 | 37.735287702767 | -122.410297269721 | (37.735287702767, -122.410297269721) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 76631 | 76631 | 207009 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 451 Hearst Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998610.96321 | 2094365.8508 | 37.7306499124634 | -122.44712329519699 | (37.7306499124634, -122.447123295197) | |||
| 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) | ||
| 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) | ||
| 52837 | 52837 | 207008 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 451 Hearst Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5998589.10288 | 2094366.3057 | 37.730649912467 | -122.447198902106 | (37.730649912467, -122.447198902106) | |||
| 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) | ||
| 170337 | 170337 | 227090 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6009411.625 | 2095915.20486 | 37.7355153013828 | -122.40989293540702 | (37.7355153013828, -122.409892935407) | |||
| 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) | ||
| 11827 | 11827 | 27212 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 302 Silver Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003753.294 | 2093466.8220900001 | 37.7284738543786 | -122.429281393342 | (37.7284738543786, -122.429281393342) | ||
| 2664 | 2664 | 37831 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 450X Moscow St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003870.23097 | 2090403.3538799998 | 37.720068868758105 | -122.42865884842699 | (37.7200688687581, -122.428658848427) |
| 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) | ||
| 103975 | 103975 | 108778 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 134809 | 134809 | 227089 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6009456.29094 | 2095946.4902299999 | 37.735603707435395 | -122.409740715285 | (37.7356037074354, -122.409740715285) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 12126 | 12126 | 27207 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 302 Silver Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003623.95003 | 2093470.2864400002 | 37.7284760433174 | -122.429728788952 | (37.7284760433174, -122.429728788952) | ||
| 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) | |||
| 127494 | 127494 | 108775 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 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) | ||
| 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) | ||
| 13218 | 13218 | 27205 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 302 Silver Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003575.96193 | 2093472.3389700002 | 37.7284789616109 | -122.429894832577 | (37.7284789616109, -122.429894832577) | ||
| 41197 | 41197 | 227088 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 6009533.30641 | 2096029.17809 | 37.7358350661275 | -122.409480276115 | (37.7358350661275, -122.409480276115) | |||
| 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) | ||||
| 13510 | 13510 | 27162 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1700X Silver Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 6011270.310880001 | 2095195.56425 | 37.733643313074204 | -122.40341610708 | (37.7336433130742, -122.40341610708) | ||
| 31459 | 31459 | 227146 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 266 Rivoli St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5997461.46496 | 2105891.36034 | 37.7622303876487 | -122.45192844846599 | (37.7622303876487, -122.451928448466) | |||
| 34687 | 34687 | 88066 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2055 Silver Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51066 | 6012463.39117 | 2096075.79817 | 37.736126817888 | -122.399353026719 | (37.736126817888, -122.399353026719) | |
| 115794 | 115794 | 108772 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 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) | |||
| 159779 | 159779 | 227135 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 11 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5999460.85655 | 2100362.14837 | 37.7471628438967 | -122.444615908893 | (37.7471628438967, -122.444615908893) | |||
| 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) | ||
| 4355 | 4355 | 37822 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 450X Moscow St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/11/2017 09:46:00 AM | 3 | 3x3 | Permit Number 40134 | 6003933.77466 | 2090481.79158 | 37.7202878374987 | -122.428444787301 | (37.7202878374987, -122.428444787301) |
| 57528 | 57528 | 227572 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 841 Church St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004362.062530001 | 2104151.54801 | 37.7578461063327 | -122.42793790601499 | (37.7578461063327, -122.427937906015) | |||
| 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) | ||
| 152527 | 152527 | 227145 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 266 Rivoli St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997490.50245 | 2105894.70205 | 37.7622412262784 | -122.451828260367 | (37.7622412262784, -122.451828260367) | |||
| 169727 | 169727 | 227134 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 10 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5999484.90108 | 2100375.94772 | 37.747202105595 | -122.44453375672501 | (37.747202105595, -122.444533756725) | |||
| 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) | ||||
| 10843 | 10843 | 27202 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 302 Silver Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003502.33889 | 2093475.71167 | 37.7284840526724 | -122.43014959163601 | (37.7284840526724, -122.430149591636) | ||
| 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) | |||
| 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) | ||||
| 35827 | 35827 | 227133 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 9 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5999502.6369199995 | 2100390.28597 | 37.7472424869628 | -122.44447345808999 | (37.7472424869628, -122.44447345809) | |||
| 103944 | 103944 | 112029 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2101x 22nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 9x9 | 6011761.0 | 2103726.0 | 37.757093449930004 | -122.402319220858 | (37.75709344993, -122.402319220858) | ||
| 133135 | 133135 | 227087 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009571.148469999 | 2096096.9094 | 37.736023162027294 | -122.409354219042 | (37.7360231620273, -122.409354219042) | |||
| 133333 | 133333 | 227144 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 266 Rivoli St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997515.89511 | 2105898.72706 | 37.7622537322474 | -122.451740727559 | (37.7622537322474, -122.451740727559) | |||
| 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) | ||||
| 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) | ||
| 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) | |
| 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) | ||
| 2667 | 2667 | 37820 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 450X Moscow St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003945.80086 | 2090498.97809 | 37.7203357084188 | -122.428404441018 | (37.7203357084188, -122.428404441018) |
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 112426 | 112426 | 27201 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 300 Silver Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/28/2012 12:00:00 AM | 3 | 3X3 | 6003188.8907382 | 2093541.6739542 | 37.728647412080996 | -122.431237903911 | (37.728647412081, -122.431237903911) | ||
| 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) | ||
| 144080 | 144080 | 47592 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 14407 | 14407 | 27158 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1700X Silver Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 6011192.5837900005 | 2095136.52795 | 37.7334768701528 | -122.403680681311 | (37.7334768701528, -122.403680681311) | ||
| 23771 | 23771 | 116544 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 3x3 | 6001586.02621 | 2088182.95127 | 37.713842599620904 | -122.436395723209 | (37.7138425996209, -122.436395723209) | |||
| 36867 | 36867 | 227143 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 266 Rivoli St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997579.79251 | 2105906.80731 | 37.762279577867496 | -122.45152031451 | (37.7622795778675, -122.45152031451) | |||
| 42969 | 42969 | 95722 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 950 Avalon Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | |
| 59010 | 59010 | 116551 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 3x3 | 6001523.56178 | 2088140.13665 | 37.713721490625 | -122.43660856033199 | (37.713721490625, -122.436608560332) | |||
| 63881 | 63881 | 129374 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 454 Walnut St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5998634.47077 | 2115144.9555599997 | 37.7877054985629 | -122.448537946784 | (37.7877054985629, -122.448537946784) | |||
| 73263 | 73263 | 129389 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2507 Larkin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006655.24817 | 2120043.6921200003 | 37.801611544485205 | -122.421135524881 | (37.8016115444852, -122.421135524881) | |||
| 80279 | 80279 | 108768 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 113705 | 113705 | 112586 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | ||||
| 115109 | 115109 | 87558 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 3906 Judah St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2015 05:19:00 PM | 3 | 5982438.0 | 2105598.0 | 37.7605529521075 | -122.50386633030199 | (37.7605529521075, -122.503866330302) | |||
| 133941 | 133941 | 227561 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 84 Seward St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6000738.66154 | 2104570.78605 | 37.7587915779822 | -122.44049917592 | (37.7587915779822, -122.44049917592) | |||
| 135940 | 135940 | 176875 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012929.76757 | 2086570.3757 | 37.710052832254796 | -122.39707427417801 | (37.7100528322548, -122.397074274178) | |||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 11575 | 11575 | 27064 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 801 Silver Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2009 12:00:00 AM | 1 | 4 | 6007054.44286 | 2093598.3683099998 | 37.7290213868102 | -122.41787844665899 | (37.7290213868102, -122.417878446659) | ||
| 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) | |||
| 44951 | 44951 | 227560 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 84 Seward St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6000737.03493 | 2104555.7602 | 37.758750228049294 | -122.44050372379101 | (37.7587502280493, -122.440503723791) | |||
| 51471 | 51471 | 116543 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 3x3 | 6001574.8493099995 | 2088164.89401 | 37.713792383287796 | -122.43643306305 | (37.7137923832878, -122.43643306305) | |||
| 59198 | 59198 | 227086 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 6009619.77164 | 2096165.8193400002 | 37.7362150980513 | -122.409190969587 | (37.7362150980513, -122.409190969587) |
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");