Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 147 | 147 | 58021 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4026 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:07:00 PM | 3 | Permit Number 16988 | 5983218.6194 | 2106316.5419 | 37.7625717348083 | -122.50121971656999 | (37.7625717348083, -122.50121971657) | ||
| 4697 | 4697 | 60547 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 507 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/2017 09:50:00 AM | 3 | Permit Number 20157 | 5984999.38205 | 2112385.8100400004 | 37.779340631831495 | -122.49550845523501 | (37.7793406318315, -122.495508455235) | |
| 11819 | 11819 | 115757 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1718 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772425 | 5998122.34061 | 2088716.2129099998 | 37.715109392747294 | -122.44840583185899 | (37.7151093927473, -122.448405831859) | ||
| 11861 | 11861 | 117431 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 730 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776696 | 6004211.115780001 | 2091567.32576 | 37.7232841663055 | -122.42756340763901 | (37.7232841663055, -122.427563407639) | ||
| 12904 | 12904 | 117426 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 395 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 775297 | 6003998.920059999 | 2091015.17385 | 37.7217560742586 | -122.428257595231 | (37.7217560742586, -122.428257595231) | ||
| 13144 | 13144 | 108829 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 545 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6012931.90275 | 2086607.7470099998 | 37.7101555653976 | -122.397069513169 | (37.7101555653976, -122.397069513169) | ||
| 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) | ||
| 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) | |
| 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) | ||||
| 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) | |
| 41903 | 41903 | 73594 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 780 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2014 12:00:00 AM | 3 | Permit Number 772812 | 6008453.79298 | 2114896.74793 | 37.787580529660794 | -122.41454729843399 | (37.7875805296608, -122.414547298434) | |
| 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) | |
| 79007 | 79007 | 107987 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 233 Laidley St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/10/2014 12:00:00 AM | 3 | Permit Number 771182 | 6004231.95883 | 2097050.3446 | 37.7383404878499 | -122.427881865747 | (37.7383404878499, -122.427881865747) | |||
| 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) | |
| 86531 | 86531 | 54968 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 526 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2015 12:00:00 AM | 3 | Permit Number 775624 | 5993160.60664 | 2111866.07895 | 37.7783880954675 | -122.46723780492201 | (37.7783880954675, -122.467237804922) | ||
| 95419 | 95419 | 117055 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 762 34th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2016 12:00:00 AM | 3 | Permit Number 778404 | 5985439.6 | 2110687.7 | 37.7747038750392 | -122.49386040463101 | (37.7747038750392, -122.493860404631) | |||
| 95544 | 95544 | 58020 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4020 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2016 11:16:00 AM | 3 | Permit Number 16987 | 5983299.23983496 | 2106318.86318391 | 37.7625828423592 | -122.500941055889 | (37.7625828423592, -122.500941055889) | ||
| 103563 | 103563 | 108764 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 3 | 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) | |
| 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) | |
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |
| 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) | |
| 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) | ||
| 141540 | 141540 | 115381 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1657X York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 775521 | 6010720.61658 | 2099977.2132599996 | 37.7467419766429 | -122.405653246985 | (37.7467419766429, -122.405653246985) | ||
| 155267 | 155267 | 70408 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 266 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 3 | 6006531.16259 | 2092699.03842 | 37.7265225593592 | -122.419623688079 | (37.7265225593592, -122.419623688079) | ||
| 11019 | 11019 | 27182 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 214 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/03/2015 07:50:00 AM | 3 | 2X3 | 6002674.64617 | 2093876.5721099998 | 37.72953781082239 | -122.433039593603 | (37.7295378108224, -122.433039593603) | ||
| 11229 | 11229 | 27181 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 225 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 3 | 2X3 | 6002702.00816 | 2093915.39197 | 37.7296459533895 | -122.432947772843 | (37.7296459533895, -122.432947772843) | ||
| 11504 | 11504 | 25763 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1682 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/20/2015 06:02:00 PM | 3 | 2X3 | 6004184.86566 | 2087196.3858299998 | 37.711281031873 | -122.42734293164801 | (37.711281031873, -122.427342931648) | ||
| 11808 | 11808 | 27083 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 773 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2007 12:00:00 AM | 3 | 2X3 | 6006444.73415 | 2093622.02758 | 37.729052017734794 | -122.419987938702 | (37.7290520177348, -122.419987938702) | ||
| 12018 | 12018 | 27177 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 241 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2005 12:00:00 AM | 3 | 2X3 | 6002847.37275 | 2093824.8510200002 | 37.729405592491496 | -122.432438768257 | (37.7294055924915, -122.432438768257) | ||
| 12093 | 12093 | 27089 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 725 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2009 12:00:00 AM | 3 | 2X3 | 6006167.96193 | 2093597.45552 | 37.728968950933 | -122.420943019604 | (37.728968950933, -122.420943019604) | ||
| 12272 | 12272 | 27179 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 231 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/27/2009 12:00:00 AM | 3 | 2X3 | 6002801.57598 | 2093850.9514400002 | 37.729474661304295 | -122.432598955494 | (37.7294746613043, -122.432598955494) | ||
| 121418 | 121418 | 27081 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 799X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3 | 2X3 | 6006577.59669 | 2093640.7294700001 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | ||
| 141 | 141 | 832 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1396 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:18:00 PM | 3 | 3X3 | 5981551.7086 | 2105613.8347 | 37.7605442750604 | -122.50693272862101 | (37.7605442750604, -122.506932728621) | ||
| 144 | 144 | 11598 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4134 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 11:51:00 AM | 3 | 3X3 | 5981663.7126 | 2105589.2786 | 37.760483446414796 | -122.506543543521 | (37.7604834464148, -122.506543543521) | ||
| 150 | 150 | 11606 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4200x Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 11:54:00 AM | 3 | 3X3 | 5981492.2847 | 2105581.1189 | 37.76045094714279 | -122.507135818078 | (37.7604509471428, -122.507135818078) | ||
| 152 | 152 | 24532 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1395 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:21:00 PM | 3 | 3X3 | 5981507.2257 | 2105680.0147 | 37.7607233666377 | -122.50709148147499 | (37.7607233666377, -122.507091481475) | ||
| 165 | 165 | 11582 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4000 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 11:49:00 AM | 3 | 3X3 | 5982109.291 | 2105604.0369 | 37.760550193841404 | -122.505003612665 | (37.7605501938414, -122.505003612665) | ||
| 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) | ||
| 4258 | 4258 | 19062 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 174 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2017 08:47:00 AM | 3 | 3X3 | 5995225.08055 | 2087462.80286 | 37.7115017488702 | -122.458329272374 | (37.7115017488702, -122.458329272374) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 11119 | 11119 | 27314 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 884 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | 3 | 3X3 | 6007123.27309 | 2093533.58449 | 37.728847377904394 | -122.41763590486799 | (37.7288473779044, -122.417635904868) | ||
| 11161 | 11161 | 27102 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 669 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2009 12:00:00 AM | 3 | 3X3 | 6005822.11431 | 2093583.57584 | 37.7289113394767 | -122.422137656546 | (37.7289113394767, -122.422137656546) | ||
| 11394 | 11394 | 27044 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 750 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1999 12:00:00 AM | 3 | 3X3 | 6006334.59281 | 2093563.7909400002 | 37.7288859066417 | -122.42036457476001 | (37.7288859066417, -122.42036457476) | ||
| 11460 | 11460 | 11602 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4150 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/2011 12:00:00 AM | 3 | 3X3 | 5981591.6344 | 2105586.8054 | 37.7604724115264 | -122.506792641078 | (37.7604724115264, -122.506792641078) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 12497 | 12497 | 27237 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 279 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2007 12:00:00 AM | 3 | 3X3 | 6003060.07524 | 2093688.7909799998 | 37.7290440614247 | -122.43169372578501 | (37.7290440614247, -122.431693725785) | ||
| 12688 | 12688 | 27048 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 896 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2009 12:00:00 AM | 3 | 3X3 | 6007189.55023 | 2093517.44233 | 37.7288067843062 | -122.417405636178 | (37.7288067843062, -122.417405636178) | ||
| 12790 | 12790 | 27106 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 559 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/2009 12:00:00 AM | 3 | 3X3 | 6005090.492430001 | 2093546.0118 | 37.7287669038667 | -122.42466425684299 | (37.7287669038667, -122.424664256843) | ||
| 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) | ||
| 12863 | 12863 | 27284 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 636 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2009 12:00:00 AM | 3 | 3X3 | 6005588.17954 | 2093528.26307 | 37.7287462653044 | -122.422942457136 | (37.7287462653044, -122.422942457136) | ||
| 13205 | 13205 | 27117 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 415 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/2009 12:00:00 AM | 3 | 3X3 | 6004172.1589 | 2093507.5126900002 | 37.7286092859714 | -122.42783625385701 | (37.7286092859714, -122.427836253857) | ||
| 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) | ||
| 17806 | 17806 | 25338 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 297x Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/03/2015 02:44:00 PM | 3 | 3X3 | 5994177.957230001 | 2087395.7640200001 | 37.7112574471386 | -122.46194351998699 | (37.7112574471386, -122.461943519987) | ||
| 21386 | 21386 | 19350 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 618 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/06/2014 12:00:00 AM | 3 | 3X3 | Permit Number 774109 | 5992350.09465 | 2089866.75515 | 37.7179367902328 | -122.468440675709 | (37.7179367902328, -122.468440675709) | |
| 80627 | 80627 | 24740 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/07/2012 12:00:00 AM | 3 | 3X3 | 5982774.3423 | 2112574.7084 | 37.779728751764104 | -122.503219660118 | (37.7797287517641, -122.503219660118) | ||
| 85269 | 85269 | 11589 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4050X Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/19/2016 11:29:00 AM | 3 | 3X3 | 5981992.356728501 | 2105594.1635633 | 37.760516204039604 | -122.50540729614599 | (37.7605162040396, -122.505407296146) | ||
| 87607 | 87607 | 11573 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 3906 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/10/2015 07:56:00 AM | 3 | 3X3 | 5982438.0 | 2105598.0 | 37.7605529521075 | -122.50386633030199 | (37.7605529521075, -122.503866330302) | ||
| 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) | ||
| 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) | ||
| 113212 | 113212 | 11603 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4245 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2015 05:31:00 PM | 3 | 3X3 | 5981392.296520599 | 2105523.6051476 | 37.7602871413722 | -122.507477357537 | (37.7602871413722, -122.507477357537) | ||
| 115374 | 115374 | 27123 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2095X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2011 12:00:00 AM | 3 | 3X3 | 6012407.8106259005 | 2096047.4553772 | 37.736045896585495 | -122.399543203223 | (37.7360458965855, -122.399543203223) | ||
| 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) | ||
| 120335 | 120335 | 27286 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 682 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 3 | 3X3 | 6005885.56477 | 2093523.1174 | 37.7287489124796 | -122.421914010506 | (37.7287489124796, -122.421914010506) | ||
| 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) | ||
| 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) | ||
| 156 | 156 | 54712 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4508 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 11:58:00 AM | 3 | 3x3 | Permit Number 10547 | 5981730.2931 | 2106265.9364 | 37.762345274891 | -122.506363455406 | (37.762345274891, -122.506363455406) | |
| 159 | 159 | 97322 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1055 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:42:00 PM | 3 | 3x3 | 5989910.3078 | 2099001.0945 | 37.7428761380219 | -122.477541124233 | (37.7428761380219, -122.477541124233) | ||
| 164 | 164 | 97323 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1011 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:25:00 PM | 3 | 3x3 | 5990005.0659 | 2099005.494 | 37.7428937161431 | -122.477213802134 | (37.7428937161431, -122.477213802134) | ||
| 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) | ||
| 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) | ||
| 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) |
| 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) | ||
| 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) | ||
| 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) |
| 4367 | 4367 | 253150 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 450X Moscow St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/11/2017 09:41:00 AM | 3 | 3x3 | 6003965.721940001 | 2090553.1315400002 | 37.7204855291627 | -122.42833943800899 | (37.7204855291627, -122.428339438009) | |
| 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) | ||
| 10693 | 10693 | 37723 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3001 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2015 05:05:00 PM | 3 | 3x3 | Permit Number 774917 | 5983867.1917 | 2098797.5436 | 37.741964716019396 | -122.498421176446 | (37.7419647160194, -122.498421176446) | |
| 10849 | 10849 | 37721 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3001 Taraval St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2015 05:19:00 PM | 3 | 3x3 | Permit Number 774917 | 5983882.4138 | 2098796.867 | 37.74196375089279 | -122.498368494175 | (37.7419637508928, -122.498368494175) | |
| 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) |
| 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) |
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");