Street_Tree_List

Data source: data.sfgov.org

977 rows where qSpecies = 48

View and edit SQL

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
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 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)
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)
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)
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 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)
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 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 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)
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)
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)
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)
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)
1364 251507 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 51 Commonwealth Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5996476.0 2114178.0 37.784926844945396 -122.45593586593901 (37.7849268449454, -122.455935865939)
1365 251509 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 51 Commonwealth Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5996476.0 2114178.0 37.784926844945396 -122.45593586593901 (37.7849268449454, -122.455935865939)
1367 36152 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 51 Commonwealth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/1998 12:00:00 AM 4   Permit Number 39237 5996489.9045 2114249.7041 37.7851245233187 -122.455892946486 (37.7851245233187, -122.455892946486)
1372 251508 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 51 Commonwealth Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5996476.0 2114178.0 37.784926844945396 -122.45593586593901 (37.7849268449454, -122.455935865939)
1375 251506 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 51 Commonwealth Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5996476.0 2114178.0 37.784926844945396 -122.45593586593901 (37.7849268449454, -122.455935865939)
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 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 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 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 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 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 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 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)
1835 251742 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 300 Naylor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002771.0 2086560.0 37.7094535905361 -122.432184185389 (37.7094535905361, -122.432184185389)
1836 251749 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 601 Prague St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002875.0 2087693.0 37.7125704580966 -122.43190559156 (37.7125704580966, -122.43190559156)
1848 251743 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 143 Cordova St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001773.0 2087479.0 37.7119203272299 -122.43569914014999 (37.7119203272299, -122.43569914015)
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)
2122 252898 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 501x Mount Vernon Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997879.0 2089997.0 37.7186122227881 -122.44933914222901 (37.7186122227881, -122.449339142229)
2369 201815 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 101 Friedell St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 6ft   6021129.2467 2093308.19399 37.7290066829092 -122.369200102111 (37.7290066829092, -122.369200102111)
2381 201818 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 2 : 4 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021088.08179 2093322.4173400002 37.7290434795636 -122.369343396492 (37.7290434795636, -122.369343396492)
2383 201821 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021045.51426 2093266.4470799998 37.7288874606638 -122.369486691782 (37.7288874606638, -122.369486691782)
2387 201822 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021035.49669 2093250.0299200001 37.72884183267921 -122.36952018972299 (37.7288418326792, -122.369520189723)
2390 201832 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020752.62591 2092874.74971 37.727795861786205 -122.370472171548 (37.7277958617862, -122.370472171548)
2391 201814 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 101 Friedell St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 6ft   6021112.10587 2093285.4865 37.728943392223 -122.36925779181699 (37.728943392223, -122.369257791817)
2400 201838 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020663.4716 2092744.71005 37.7274339035298 -122.37077139578501 (37.7274339035298, -122.370771395785)
2405 201816 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 101 Friedell St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 6ft   6021143.08428 2093327.21502 37.729059670062206 -122.36915357747299 (37.7290596700622, -122.369153577473)
2406 201829 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 284 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020846.41585 2093000.7945400001 37.7281471046068 -122.37015664263399 (37.7281471046068, -122.370156642634)
2408 201820 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021056.53291 2093279.09213 37.728922786051506 -122.369449472416 (37.7289227860515, -122.369449472416)
2409 201824 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 8 : 4 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021004.603680001 2093212.5880900002 37.728737329640495 -122.369624404053 (37.7287373296405, -122.369624404053)
2410 201817 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 1 : 4 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021101.98762 2093338.62944 37.7290887577236 -122.36929644199101 (37.7290887577236, -122.369296441991)
2411 201831 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020768.36275 2092897.8842900002 37.7278602487283 -122.37041936696698 (37.7278602487283, -122.370419366967)
2417 201819 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021071.50009 2093300.7706900002 37.7289831323462 -122.369399226393 (37.7289831323462, -122.369399226393)
2419 201835 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020706.7385 2092807.85492 37.72760966254629 -122.370626184075 (37.7276096625463, -122.370626184075)
2423 201830 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 292 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020827.60649 2092975.44043 37.7280764547545 -122.370219916224 (37.7280764547545, -122.370219916224)
2435 201826 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 250 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020898.42083 2093071.04954 37.7283428654122 -122.369981710984 (37.7283428654122, -122.369981710984)
2438 201823 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 7 : 4 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021023.85438 2093233.10906 37.728794732485206 -122.369559269737 (37.7287947324852, -122.369559269737)
2444 201828 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 268 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020862.97624 2093021.3694799999 37.728204508308 -122.3701008136 (37.728204508308, -122.3701008136)
2446 201827 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 258 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020879.65439 2093047.83852 37.7282781025329 -122.370044984594 (37.7282781025329, -122.370044984594)
2452 201837 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020676.58787 2092764.09442 37.7274878493838 -122.370727391967 (37.7274878493838, -122.370727391967)
2453 201836 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020688.4191 2092782.87071 37.7275400550072 -122.370687788509 (37.7275400550072, -122.370687788509)
2454 201833 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020733.63229 2092847.8779900002 37.727721034575296 -122.370535976659 (37.7277210345753, -122.370535976659)
2460 201825 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 232 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020928.29141 2093111.1924700001 37.7284547293849 -122.36988121894899 (37.7284547293849, -122.369881218949)
2461 201834 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020718.56969 2092826.63123 37.7276618681873 -122.37058658062 (37.7276618681873, -122.37058658062)
2466 201813 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 101 Friedell St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 6ft   6021086.18405 2093254.37787 37.728856551886395 -122.369345258092 (37.7288565518864, -122.369345258092)
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 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 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)
2676 253162 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 323 Moscow St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6004481.0 2091226.0 37.7223622223708 -122.42660617515699 (37.7223622223708, -122.426606175157)
3788 118108 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 3585 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/25/2017 12:00:00 AM 3 Width 3ft   5984519.42575 2111051.46948 37.7756488017479 -122.497070281467 (37.7756488017479, -122.497070281467)
3913 253116 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 26 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 12:00:00 PM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3915 160069 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:26:00 AM 3 Width 0ft   6000296.79811 2090527.7878900003 37.7202076512361 -122.441019880684 (37.7202076512361, -122.441019880684)
3918 253108 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:41:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3922 160059 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 10:50:00 AM 3 Width 0ft   6000588.557440001 2091082.6412900002 37.7217477663201 -122.440051133668 (37.7217477663201, -122.440051133668)
3928 253114 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 24 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:55:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3934 160071 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:31:00 AM 3 Width 0ft   6000209.4859 2090450.10808 37.7199893866688 -122.44131611827 (37.7199893866688, -122.44131611827)
3935 160073 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:36:00 AM 3 Width 0ft   6000082.999340001 2090399.7386 37.7198438772755 -122.44174972458201 (37.7198438772755, -122.441749724582)
3937 253112 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 22 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:51:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3939 160065 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:13:00 AM 3 Width 0ft   6000417.53141 2090750.6791299998 37.7208265358932 -122.440618525839 (37.7208265358932, -122.440618525839)
3946 160063 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:07:00 AM 3 Width 0ft   6000471.59074 2090857.9533099998 37.7211241647202 -122.440439349407 (37.7211241647202, -122.440439349407)
3950 162332 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 36 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 02:06:00 PM 3 Width 0ft   5996526.7373 2090117.21242 37.718864853708205 -122.45402201441001 (37.7188648537082, -122.45402201441)
3960 160061 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:02:00 AM 3 Width 0ft   6000547.454419999 2091000.21878 37.7215191128017 -122.440187308101 (37.7215191128017, -122.440187308101)
3968 253118 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 28 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 01:35:00 PM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3971 251681 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 4 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 02:36:00 PM 3 3x5   5996550.0 2089909.0 37.7182944850221 -122.453926576307 (37.7182944850221, -122.453926576307)
3973 253110 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 20 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:46:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3974 162331 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 26 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 02:09:00 PM 3 Width 0ft   5996526.61739 2090076.5104099999 37.7187530886569 -122.454019490912 (37.7187530886569, -122.454019490912)
3982 159338 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 517 Ellington Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:04:00 AM 3 Width 0ft   5998112.9338 2087183.20699 37.7108995709325 -122.44832801714199 (37.7108995709325, -122.448328017142)
3992 159336 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 523 Ellington Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 10:36:00 AM 3 Width 0ft   5998080.57171 2087152.95418 37.7108146533454 -122.448437690352 (37.7108146533454, -122.448437690352)
4007 216655 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 161 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 02:49:00 PM 3 Width 3ft   5995318.74701 2090961.5845400002 37.7211139601174 -122.45825861266 (37.7211139601174, -122.45825861266)
4058 159346 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 461 Ellington Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:49:00 AM 3 Width 0ft   5998276.6806 2087336.8062099998 37.7113306798385 -122.44777312285 (37.7113306798385, -122.44777312285)
4070 159339 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 517 Ellington Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:12:00 AM 3 Width 0ft   5998126.4578599995 2087195.02696 37.710932799068104 -122.44828212563 (37.7109327990681, -122.44828212563)
4072 159348 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 461 Ellington Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:44:00 AM 3 Width 0ft   5998312.68186 2087372.3667799998 37.711430378688796 -122.447651252104 (37.7114303786888, -122.447651252104)
4077 159345 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 461 Ellington Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:39:00 AM 3 Width 0ft   5998268.07471 2087327.6085 37.7113049331395 -122.447802205131 (37.7113049331395, -122.447802205131)
4091 159347 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 461 Ellington Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:27:00 AM 3 Width 0ft   5998288.37354 2087349.92963 37.711367382076396 -122.44773365338999 (37.7113673820764, -122.44773365339)
4096 181028 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 95 Rolph St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 04:38:00 PM 3 Width 4ft   6000533.08885 2088674.4676599998 37.715132307492794 -122.44007027934201 (37.7151323074928, -122.440070279342)
4113 181027 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 95 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 04:23:00 PM 3 Width 4ft   6000546.58685 2088667.2481099998 37.7151132526545 -122.440023107188 (37.7151132526545, -122.440023107188)
4127 207021 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 400 Grafton Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/06/2017 07:38:00 AM 3 Width 3ft   5995575.229619999 2090581.47857 37.720085014301894 -122.457344548018 (37.7200850143019, -122.457344548018)
4130 216848 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 258 Farallones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/06/2017 02:39:00 PM 3 Width 3ft   5994378.76562 2088424.12647 37.7140926462446 -122.461323980613 (37.7140926462446, -122.461323980613)
4142 216723 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 51 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/06/2017 08:05:00 AM 3 Width 2ft   5995305.86266 2090248.9874099998 37.7191565973781 -122.458251599737 (37.7191565973781, -122.458251599737)
4192 216845 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 194 Farallones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 07:48:00 AM 3 Width 3ft   5995118.95449 2088413.12295 37.714105005620205 -122.458764825742 (37.7141050056202, -122.458764825742)
4220 181020 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 183 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 12:41:00 PM 3 Width 4ft   6000952.49174 2088426.9301099998 37.714476492181895 -122.438602919392 (37.7144764921819, -122.438602919392)
4227 181017 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 197 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 11:28:00 AM 3 Width 4ft   6001019.31887 2088386.79799 37.7143700996689 -122.43836906510201 (37.7143700996689, -122.438369065102)
4245 181019 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 191 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 12:36:00 PM 3 Width 4ft   6000981.45407 2088409.26942 37.714429647391896 -122.438501549606 (37.7144296473919, -122.438501549606)
4257 181010 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 215 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 11:17:00 AM 3 Width 4ft   6001139.6561 2088316.9005900002 37.7141850209845 -122.437948129327 (37.7141850209845, -122.437948129327)
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)
4266 181021 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 179 Rolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 12:49:00 PM 3 8x6   6000934.6994199995 2088437.13017 37.71450348711 -122.438665147076 (37.71450348711, -122.438665147076)
4270 252889 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 301x Howth St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 03:58:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4273 181018 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 197 Rolph St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 11:31:00 AM 3 Width 4ft   6001005.57228 2088396.0469099998 37.714394713229105 -122.43841724088999 (37.7143947132291, -122.43841724089)

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 506.502ms · Data source: data.sfgov.org