Street_Tree_List

Data source: data.sfgov.org

977 rows where qSpecies = 48

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
4276 180842 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 87 Laura St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 03:54:00 PM 3 Width 2ft   5997291.8877 2087045.22216 37.710473721248 -122.45115578601299 (37.710473721248, -122.451155786013)
4282 251444 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 244 Farallones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 07:40:00 AM 3 3x3   5994545.0 2088436.0 37.7141348140673 -122.460750275072 (37.7141348140673, -122.460750275072)
4306 181011 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 207 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 11:21:00 AM 3 Width 4ft   6001121.315830001 2088326.0025400002 37.714208969932706 -122.438012171843 (37.7142089699327, -122.438012171843)
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 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)
4375 176488 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 295 Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 09:25:00 AM 3 Width 2ft   6004452.7164199995 2090718.28415 37.7209665468512 -122.4266678079 (37.7209665468512, -122.4266678079)
4432 172375 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 216 Naylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 07:37:00 AM 3 Width 2ft   6002574.0 2086750.0 37.7099641176609 -122.432878614235 (37.7099641176609, -122.432878614235)
4451 216718 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 978 Capitol Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/13/2017 11:36:00 AM 3 Width 3ft   5995057.03199 2090421.24862 37.7196152839906 -122.45912417326299 (37.7196152839906, -122.459124173263)
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)
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 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 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 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 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)
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)
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 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 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 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 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 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 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)
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)
10352 27283 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 630 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/11/2008 12:00:00 AM 6 3X3   6005560.769069999 2093525.90712 37.7287382496569 -122.423037049614 (37.7287382496569, -122.423037049614)
10369 83563 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 422 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2012 12:00:00 AM 5 3x3 Permit Number 769753 6002333.8721199995 2090986.9240400002 37.721584152666104 -122.434011205875 (37.7215841526661, -122.434011205875)
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)
10468 27000 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1236 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2007 12:00:00 AM 6 3X3   6008836.56983 2094066.26048 37.7304062528391 -122.411750521985 (37.7304062528391, -122.411750521985)
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 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)
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)
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)
10740 27042 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 730 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2007 12:00:00 AM 6 3X3   6006159.1890199995 2093550.7367900002 37.7288401770086 -122.420970032554 (37.7288401770086, -122.420970032554)
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)
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 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)
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 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)
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)
11129 57147 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 578 London St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2012 12:00:00 AM 6 4x4 Permit Number 14422 6001353.29798 2090440.6981099998 37.720028641190204 -122.4373616868 (37.7200286411902, -122.4373616868)
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)
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)
11210 27282 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 710 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2007 12:00:00 AM 6 3X3   6006026.1077 2093547.18457 37.7288229208214 -122.421429852322 (37.7288229208214, -122.421429852322)
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)
11343 37722 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 3001 Taraval St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/27/2015 04:53:00 PM 3 3x3 Permit Number 774917 5983850.6165 2098795.1757 37.741957242405206 -122.498478312402 (37.7419572424052, -122.498478312402)
11369 83554 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 117X Peru Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769748 6003920.58239 2093359.5974299998 37.728188908672294 -122.428695428367 (37.7281889086723, -122.428695428367)
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 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 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 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)
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)
11687 83518 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 117X Peru Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769748 6003951.4498 2093338.17621 37.7281318376981 -122.428587192249 (37.7281318376981, -122.428587192249)
11715 26976 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 504X Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/2007 12:00:00 AM 3 3x3   6004631.3919400005 2093482.01374 37.7285652398765 -122.42624684333201 (37.7285652398765, -122.426246843332)
11736 26988 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1339 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/29/2009 12:00:00 AM 6 3X3   6009367.01038 2094339.1416200001 37.731185268979395 -122.409935962601 (37.7311852689794, -122.409935962601)
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)
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)
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)
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)
11936 109688 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 610 Russia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/27/2015 12:00:00 AM 3 3x3 Permit Number 774167 6002866.933730001 2090069.7229400002 37.719095959684 -122.432103090885 (37.719095959684, -122.432103090885)
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)
12031 37717 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 3001 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/27/2015 04:45:00 PM 3 3x3 Permit Number 774917 5983817.4661 2098794.1609 37.7419525119456 -122.498592859082 (37.7419525119456, -122.498592859082)
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 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)
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)
12172 80104 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 425 Brazil Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/03/2005 12:00:00 AM 3 3x3 Permit Number 52309 6003144.80516 2091503.7027099999 37.7230491006299 -122.43124489934999 (37.7230491006299, -122.43124489935)
12199 27193 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 284 Silver Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/27/2009 12:00:00 AM 6 3X3   6003096.09594 2093601.65823 37.7288068562446 -122.431562981455 (37.7288068562446, -122.431562981455)
12241 27220 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 387 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/03/2009 12:00:00 AM 6 3X3   6003946.676519999 2093508.2167200001 37.728598460843294 -122.42861580957899 (37.7285984608433, -122.428615809579)
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)
12306 27287 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1036 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2008 12:00:00 AM 6 3X3   6007731.14975 2093596.42391 37.729054108643 -122.415538874723 (37.729054108643, -122.415538874723)
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)
12350 83555 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 117X Peru Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769748 6003936.8249699995 2093347.62291 37.7281569485605 -122.428638423918 (37.7281569485605, -122.428638423918)
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 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)
12537 109577 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 10X Santa Rosa Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/24/2015 12:00:00 AM 3 3x3 Permit Number 775018 6002290.3134 2092582.02308 37.72596146424 -122.434275755847 (37.72596146424, -122.434275755847)
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)
12620 27251 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 547 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 2X3   6005015.49022 2093543.0573099998 37.7287545552706 -122.424923334442 (37.7287545552706, -122.424923334442)
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 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)
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)
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 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)
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)
12933 27010 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1462 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/02/1999 12:00:00 AM 6 3X3   6010153.37045 2094576.2882400001 37.7318804638018 -122.407234074496 (37.7318804638018, -122.407234074496)
12940 27051 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1008 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2007 12:00:00 AM 6 3x3   6007619.46607 2093557.16905 37.7289400449304 -122.415922196353 (37.7289400449304, -122.415922196353)
13061 27046 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 790 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/29/2009 12:00:00 AM 6 3X3   6006496.082169999 2093583.10222 37.728948030017904 -122.419807663316 (37.7289480300179, -122.419807663316)
13067 83533 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 242 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/2012 12:00:00 AM 5 3x3 Permit Number 769751 6002979.54268 2092016.08462 37.724446620113 -122.43185274573099 (37.724446620113, -122.431852745731)
13068 109689 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 836 Russia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/27/2015 12:00:00 AM 3 3x3 Permit Number 774161 6003406.50306 2089728.7354700002 37.7181902596385 -122.430213694415 (37.7181902596385, -122.430213694415)
13072 27052 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1016 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/27/1999 12:00:00 AM 6 3X3   6007658.95865 2093571.8872599998 37.7289826781912 -122.415786708996 (37.7289826781912, -122.415786708996)
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)
13204 27035 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1300X Silver Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/27/1999 12:00:00 AM 6 3X3   6009326.50967 2094276.52484 37.731011066700894 -122.410071562372 (37.7310110667009, -122.410071562372)
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)
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)
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 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)
13749 68842 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 602 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/27/2004 12:00:00 AM 5 3x3 Permit Number 767166 6014359.28345 2104329.14494 37.7588942535933 -122.39337550020399 (37.7588942535933, -122.393375500204)
13879 50774 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47304          
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)
14988 27169 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2080 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/16/1999 12:00:00 AM 6 2x3   6012550.77406 2096074.9927599998 37.73612947627829 -122.39905085001999 (37.7361294762783, -122.39905085002)
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)
16012 88475 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2350 Jerrold Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/18/2008 12:00:00 AM 3 3x3 Permit Number 51428 6011686.38123 2099767.14104 37.7462191214225 -122.402298941348 (37.7462191214225, -122.402298941348)
16132 88474 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2350 Jerrold Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/18/2008 12:00:00 AM 3 3x3 Permit Number 51428 6011695.42869 2099760.86607 37.7462023967426 -122.402267215055 (37.7462023967426, -122.402267215055)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 15.155ms · Data source: data.sfgov.org