Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus ▲ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79719 | 79719 | 112585 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | ||||
| 82449 | 82449 | 112583 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | |||
| 108178 | 108178 | 112584 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | ||||
| 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) | ||||
| 98766 | 98766 | 104736 | Significant Tree 6 | Lagunaria patersonii :: Primrose Tree 48 | 1499X 44th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770763 | 5982473.05016 | 2105245.16297 | 37.7595862228156 | -122.50371897878901 | (37.7595862228156, -122.503718978789) | ||||
| 144924 | 144924 | 114895 | Private 5 | Lagunaria patersonii :: Primrose Tree 48 | 820 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2015 12:00:00 AM | Permit Number 775427 | 5986664.4 | 2110325.3 | 37.7737804103986 | -122.489596975753 | (37.7737804103986, -122.489596975753) | |||
| 98279 | 98279 | 120680 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 522 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2016 12:00:00 AM | 3 | 3x3 | 6003717.0 | 2090174.0 | 37.719430440149104 | -122.42917217063999 | (37.7194304401491, -122.42917217064) | ||
| 101502 | 101502 | 111713 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 3038 CLEMENT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051.0 | 2113265.0 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | |
| 145461 | 145461 | 111714 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 3038 CLEMENT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051.0 | 2113265.0 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | |
| 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) | ||
| 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) | ||
| 179 | 179 | 182083 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1101 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:33:00 PM | 3 | Width 0ft | 5989775.2775 | 2098997.3719 | 37.742858080169505 | -122.47800774412599 | (37.7428580801695, -122.478007744126) | ||
| 1386 | 1386 | 183693 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.6569 | 2105897.5428 | 37.7614111825323 | -122.501783460946 | (37.7614111825323, -122.501783460946) | ||
| 1390 | 1390 | 183692 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983047.3598 | 2105912.7714 | 37.761453037237 | -122.501782156698 | (37.761453037237, -122.501782156698) | ||
| 1404 | 1404 | 183694 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983048.5312 | 2105875.9885 | 37.7613521106328 | -122.501775383852 | (37.7613521106328, -122.501775383852) | ||
| 1408 | 1408 | 183696 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983051.3079 | 2105837.6039 | 37.7612468805065 | -122.50176294055599 | (37.7612468805065, -122.501762940556) | ||
| 1417 | 1417 | 183690 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983045.4855 | 2105953.0685 | 37.7615635715471 | -122.50179162058001 | (37.7615635715471, -122.50179162058) | ||
| 1419 | 1419 | 183699 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983053.3747 | 2105791.1008 | 37.761119317578505 | -122.501752351825 | (37.7611193175785, -122.501752351825) | ||
| 1428 | 1428 | 183691 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.4226 | 2105931.5142 | 37.76150444459871 | -122.50178678479799 | (37.7615044445987, -122.501786784798) | ||
| 1430 | 1430 | 183687 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 33196 | 5983043.3769 | 2106010.2341 | 37.7617204082059 | -122.50180314292801 | (37.7617204082059, -122.501803142928) | |
| 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) | ||
| 2643 | 2643 | 37817 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 450X Moscow St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003961.27408 | 2090526.1025099999 | 37.7204110616965 | -122.428352887393 | (37.7204110616965, -122.428352887393) |
| 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) |
| 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) |
| 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) | ||
| 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) | |
| 4929 | 4929 | 3534 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 201X Cargo Way | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:10:00 AM | 3 | 3X3 | 6018402.129369999 | 2097818.41667 | 37.7412409080406 | -122.378941151133 | (37.7412409080406, -122.378941151133) | ||
| 4939 | 4939 | 3523 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 201X Cargo Way | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:28:00 AM | 3 | 3X3 | 6018216.35215 | 2097958.4950099997 | 37.741615290427106 | -122.379593238756 | (37.7416152904271, -122.379593238756) | ||
| 4963 | 4963 | 3516 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 201X Cargo Way | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/07/1996 12:00:00 AM | 6 | 3X3 | 6018109.71439 | 2098036.73671 | 37.7418242442879 | -122.379967395395 | (37.7418242442879, -122.379967395395) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 11046 | 11046 | 116538 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 3x3 | 6001578.1015800005 | 2088233.43486 | 37.7139807660769 | -122.436426724612 | (37.7139807660769, -122.436426724612) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 12597 | 12597 | 26986 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1349 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009414.0618 | 2094354.93302 | 37.7312312656966 | -122.409774411069 | (37.7312312656966, -122.409774411069) | |||
| 12809 | 12809 | 93466 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1649 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2015 05:27:00 PM | 3 | 3x3 | 5988055.4179 | 2098939.1633 | 37.7425982798609 | -122.483950196784 | (37.7425982798609, -122.483950196784) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 15148 | 15148 | 27156 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1700X Silver Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 6011160.21022 | 2095112.55455 | 37.7334092357479 | -122.403790920224 | (37.7334092357479, -122.403790920224) | ||
| 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) | ||
| 19267 | 19267 | 89545 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 5328 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982088.22815 | 2111702.2127400003 | 37.7772927805161 | -122.505528495685 | (37.7772927805161, -122.505528495685) | ||
| 20021 | 20021 | 858 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 400X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/24/2015 09:41:00 AM | 3 | 3x3 | 6008130.35725 | 2095075.26223 | 37.7331371107843 | -122.414263368055 | (37.7331371107843, -122.414263368055) | ||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | ||||
| 38258 | 38258 | 113355 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3X3 | 5982766.03998 | 2112575.4615 | 37.779730331527404 | -122.503248436763 | (37.7797303315274, -122.503248436763) | |||
| 44260 | 44260 | 116540 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 3x3 | 6001555.506159999 | 2088195.95431 | 37.713876568835396 | -122.43650214175399 | (37.7138765688354, -122.436502141754) | |||
| 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) | |||
| 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) | |||
| 64250 | 64250 | 116547 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 3x3 | 6001554.67745 | 2088129.8106 | 37.7136949057732 | -122.436500274771 | (37.7136949057732, -122.436500274771) | |||
| 72208 | 72208 | 90706 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4332 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982115.667719999 | 2110342.56784 | 37.773561208242704 | -122.505332776144 | (37.7735612082427, -122.505332776144) | ||
| 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) | ||
| 80905 | 80905 | 90725 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4701X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5980935.002069999 | 2110229.7439200003 | 37.773181881349004 | -122.509408420019 | (37.773181881349, -122.509408420019) | ||
| 81686 | 81686 | 90243 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2900X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/05/2015 07:19:00 AM | 3 | 3x3 | 5986256.13943 | 2111172.66934 | 37.7760832028982 | -122.491071565578 | (37.7760832028982, -122.491071565578) | ||
| 84495 | 84495 | 840 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1412 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2015 01:14:00 PM | 3 | 3x3 | 5981250.420684201 | 2105445.3666042998 | 37.7600639622975 | -122.507962224252 | (37.7600639622975, -122.507962224252) | ||
| 84962 | 84962 | 90278 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4332 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982097.18566 | 2111025.0008400003 | 37.7754338822902 | -122.50544730055 | (37.7754338822902, -122.50544730055) | ||
| 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) | ||
| 85355 | 85355 | 90715 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4530 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981529.23414 | 2110319.83024 | 37.773464252019004 | -122.507359614365 | (37.773464252019, -122.507359614365) | ||
| 87024 | 87024 | 90734 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4519 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981558.45056 | 2110264.5871200003 | 37.773314291486294 | -122.507254453094 | (37.7733142914863, -122.507254453094) | ||
| 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) | ||
| 88283 | 88283 | 90713 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4512 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981576.37852 | 2110321.34111 | 37.773471177271105 | -122.507196650108 | (37.7734711772711, -122.507196650108) | ||
| 89101 | 89101 | 90714 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4520 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981557.47501 | 2110321.74662 | 37.7734711772765 | -122.50726206903 | (37.7734711772765, -122.50726206903) | ||
| 90243 | 90243 | 90305 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4201X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982481.013259999 | 2110978.58794 | 37.775329025693104 | -122.504116133843 | (37.7753290256931, -122.504116133843) | ||
| 91576 | 91576 | 90720 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4634 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981186.20352 | 2110308.00833 | 37.7734115809285 | -122.508545307898 | (37.7734115809285, -122.508545307898) | ||
| 92563 | 92563 | 90277 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4326 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982116.47387 | 2111024.58745 | 37.7754338822795 | -122.505380548569 | (37.7754338822795, -122.505380548569) | ||
| 92744 | 92744 | 90280 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4344 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982056.98615 | 2111023.40443 | 37.775427133307204 | -122.505586239401 | (37.7754271333072, -122.505586239401) | ||
| 93450 | 93450 | 27125 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2095X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2011 12:00:00 AM | 6 | 3X3 | 6012407.8106259005 | 2096047.4553772 | 37.736045896585495 | -122.399543203223 | (37.7360458965855, -122.399543203223) | ||
| 96405 | 96405 | 89539 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 5238 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982360.37978 | 2111711.22049 | 37.7773335253891 | -122.50458771883699 | (37.7773335253891, -122.504587718837) | ||
| 96869 | 96869 | 90309 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4115 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982775.05183 | 2110989.27027 | 37.7753756437209 | -122.503099794321 | (37.7753756437209, -122.503099794321) | ||
| 98955 | 98955 | 90723 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4750X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5980837.13634 | 2110295.92473 | 37.773357823394605 | -122.50975186123199 | (37.7733578233946, -122.509751861232) | ||
| 102031 | 102031 | 90939 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4144 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5982653.54392 | 2111040.34267 | 37.7755087308719 | -122.50352389434201 | (37.7755087308719, -122.503523894342) | ||
| 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) | ||
| 104102 | 104102 | 90248 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 3040 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986089.18026 | 2111167.85377 | 37.7760602246469 | -122.491648759198 | (37.7760602246469, -122.491648759198) | ||
| 104405 | 104405 | 90971 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4101 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5982789.9497 | 2110989.59501 | 37.775377411022205 | -122.503048284011 | (37.7753774110222, -122.503048284011) | ||
| 104761 | 104761 | 28817 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1075 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6008023.971390001 | 2093752.9516900002 | 37.7295003553203 | -122.414537636128 | (37.7295003553203, -122.414537636128) | |||
| 107504 | 107504 | 90238 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2900X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986478.45159 | 2111179.35168 | 37.7761145368708 | -122.49030303077299 | (37.7761145368708, -122.490303030773) | ||
| 108236 | 108236 | 27114 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 451 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/03/2009 12:00:00 AM | 3 | 3x3 | 6004400.62614 | 2093530.84049 | 37.728686260787796 | -122.427048090034 | (37.7286862607878, -122.427048090034) | ||
| 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) | ||
| 114363 | 114363 | 90966 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4245 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5982369.3768 | 2110976.86332 | 37.775317724630604 | -122.50450217585501 | (37.7753177246306, -122.504502175855) | ||
| 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) | |||
| 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) |
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");