trees
891 rows where qSpecies_id = 75 sorted by rowid descending
This data as json, CSV (advanced)
rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194152 | 88171 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011722.12263 | 2112583.00982 | 37.78141062014 | -122.403076651689 | (37.78141062014, -122.403076651689) | 6 | 2 | 9 | 28853 | 34 | |
193868 | 115735 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776554 | 5993777.6 | 2097002.8 | 37.7376129769989 | -122.464024183823 | (37.7376129769989, -122.464024183823) | 1 | 8 | 4 | 59 | 40 | ||
193594 | 256211 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 837 Broadway | 5 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009431 | 2118388 | 37.7972215096833 | -122.411413084134 | (37.7972215096833, -122.411413084134) | 3 | 1 | 10 | 308 | 4 | ||||
193577 | 189079 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1047 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010221.55971 | 2109034.74016 | 37.771583988945 | -122.408017589961 | (37.771583988945, -122.408017589961) | 14 | 2 | 9 | 28853 | 34 | |||
193555 | 123077 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 723 12th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992233.23043 | 2110491.18489 | 37.774559431962 | -122.470345763786 | (37.774559431962, -122.470345763786) | 11 | 6 | 2 | 54 | 11 | |||
192417 | 28679 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 3125X San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 2X3 | 6011481.7390123 | 2092091.2460015 | 37.7251313079457 | -122.402466923949 | (37.7251313079457, -122.402466923949) | 10 | 3 | 7 | 309 | 28 | |||
192151 | 220471 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 100 Alemany Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009494.82238 | 2095997.42417 | 37.7357457202871 | -122.4096110906 | (37.7357457202871, -122.4096110906) | 10 | 7 | 7 | 28859 | 2 | |||
192107 | 187922 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 48 Minna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013074.69793 | 2115022.06537 | 37.7881831410762 | -122.398568572402 | (37.7881831410762, -122.398568572402) | 12 | 2 | 9 | 28855 | 6 | |||
191487 | 53153 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1397@ JENNINGS Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49077 | 6016165.18448304 | 2093562.93446239 | 37.7294326204666 | -122.386379154297 | (37.7294326204666, -122.386379154297) | 10 | 3 | 8 | 58 | 1 | ||
191156 | 112596 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1200x Divisadero St | 6 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6001324.7675 | 2112728.8365 | 37.7812249111251 | -122.439056830439 | (37.7812249111251, -122.439056830439) | 15 | 5 | 11 | 29490 | 41 | |||
191096 | 29063 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1000X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | ||
191014 | 122700 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 2895 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x9 | 6011453.69513 | 2092165.76794 | 37.7253343641976 | -122.402569107292 | (37.7253343641976, -122.402569107292) | 10 | 3 | 7 | 309 | 28 | ||
190700 | 22539 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1441X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3X6 | 6002335.85354 | 2093628.68187 | 37.728837937275 | -122.434193118021 | (37.728837937275, -122.434193118021) | 9 | 7 | 6 | 28861 | 25 | ||
190666 | 86614 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1070 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/03/2011 12:00:00 AM | 3 | 3x3 | 6010177 | 2109056 | 37.7716398686135 | -122.4081732249 | (37.7716398686135, -122.4081732249) | 14 | 2 | 9 | 28853 | 34 | ||
190387 | 203403 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 155 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5994381.0014 | 2096518.06805 | 37.736316779897 | -122.461902813967 | (37.736316779897, -122.461902813967) | 9 | 8 | 4 | 59 | 40 | |||
190217 | 175130 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 10 Watt Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000121.60352 | 2086651.00774 | 37.7095529054216 | -122.441347441633 | (37.7095529054216, -122.441347441633) | 9 | 7 | 6 | 28861 | 5 | |||
189983 | 1004 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1810X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6001283.16417 | 2091702.46996 | 37.7234891944335 | -122.437694433548 | (37.7234891944335, -122.437694433548) | 9 | 7 | 6 | 28861 | 25 | ||
189869 | 187863 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1000 22nd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6014779.35542 | 2103919.85891 | 37.7577937720836 | -122.391894064084 | (37.7577937720836, -122.391894064084) | 10 | 3 | 8 | 28856 | 29 | |||
189796 | 30769 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1642 Wallace Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 7 | Permit Number 34649 | 6014556.9626 | 2093085.2912 | 37.7280319553097 | -122.391905589486 | (37.7280319553097, -122.391905589486) | 10 | 3 | 8 | 58 | 1 | |
189783 | 2366 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2500 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009707.81579 | 2102741.7783 | 37.7542761719147 | -122.409350492245 | (37.7542761719147, -122.409350492245) | 2 | 4 | 7 | 28859 | 19 | |||
189291 | 256552 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 1 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:54:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
188501 | 187955 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014803.46542 | 2114565.35002 | 37.7870252657357 | -122.392555322966 | (37.7870252657357, -122.392555322966) | 6 | 2 | 9 | 28855 | 6 | |||
188463 | 115734 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 776555 | 5993732.7 | 2097034 | 37.7376960566374 | -122.464181687663 | (37.7376960566374, -122.464181687663) | 1 | 8 | 4 | 59 | 40 | ||||
188009 | 187883 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1600 Indiana St | 20 | : | Tree | Private 2 | 3 | Width 3ft | 6015144.84488 | 2100499.87807 | 37.7484235126495 | -122.390391088302 | (37.7484235126495, -122.390391088302) | 10 | 3 | 8 | 58 | 1 | |||
187666 | 220431 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1650 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006511.20977 | 2099774.83296 | 37.7459499992956 | -122.420194625406 | (37.7459499992956, -122.420194625406) | 2 | 7 | 7 | 28859 | 2 | |||
187602 | 220482 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3135 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008165.93149 | 2102089.85128 | 37.7523996186474 | -122.41463660112 | (37.7523996186474, -122.41463660112) | 2 | 4 | 7 | 28859 | 19 | |||
187396 | 189067 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 521 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6013772.20207 | 2112425.85547 | 37.7810933806993 | -122.395973304322 | (37.7810933806993, -122.395973304322) | 6 | 2 | 9 | 28856 | 34 | |||
186559 | 251267 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1174 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009753 | 2108692 | 37.7706166587255 | -122.409614176745 | (37.7706166587255, -122.409614176745) | 8 | 2 | 9 | 28853 | 34 | ||||
186343 | 141990 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 780 FULTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004028.4702 | 2111508.2869 | 37.7780270522314 | -122.429616280333 | (37.7780270522314, -122.429616280333) | 7 | 9 | 11 | 28852 | 41 | |||
186332 | 121541 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
186328 | 247510 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400x Divisadero St | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001703.2636 | 2110010.3317 | 37.7737821102395 | -122.437552684593 | (37.7737821102395, -122.437552684593) | 15 | 5 | 11 | 29492 | 10 | |||
186116 | 187908 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 167 Jessie St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012100.15122 | 2114661.96833 | 37.7871400579 | -122.401915035175 | (37.7871400579, -122.401915035175) | 12 | 2 | 9 | 28855 | 6 | |||
185836 | 52844 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 50 Lansing St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014342.2793 | 2114200.39615 | 37.7859975636787 | -122.394125376504 | (37.7859975636787, -122.394125376504) | 6 | 2 | 9 | 28855 | 6 | |
185429 | 28680 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3125X San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/23/2014 12:00:00 AM | 3 | 2x3 | 6011481.7390123 | 2092091.2460015 | 37.7251313079457 | -122.402466923949 | (37.7251313079457, -122.402466923949) | 10 | 3 | 7 | 309 | 28 | ||
185419 | 220426 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1501 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009442.98316 | 2107699.97849 | 37.7678754204423 | -122.410616467889 | (37.7678754204423, -122.410616467889) | 8 | 4 | 8 | 28853 | 19 | |||
185403 | 24865 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2658 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2000 12:00:00 AM | 8 | 3X3 | 6011093.9148591 | 2093183.5451124 | 37.7281088761684 | -122.403884427694 | (37.7281088761684, -122.403884427694) | 10 | 3 | 7 | 309 | 28 | ||
185206 | 247517 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 250x Divisadero St | 2 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001820.5087 | 2109214.383 | 37.771603298669 | -122.437090117747 | (37.771603298669, -122.437090117747) | 15 | 5 | 11 | 29492 | 9 | |||
184236 | 100774 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
183937 | 220478 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 211 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008820.95976 | 2097493.32849 | 37.7398153647742 | -122.412046587806 | (37.7398153647742, -122.412046587806) | 10 | 7 | 7 | 28859 | 2 | |||
183750 | 203414 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 95 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993945.56402 | 2096868.34313 | 37.7372534705646 | -122.463433702031 | (37.7372534705646, -122.463433702031) | 1 | 8 | 4 | 59 | 40 | |||
183637 | 220465 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1900 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009493.16635 | 2105815.19005 | 37.7627030371354 | -122.410309795471 | (37.7627030371354, -122.410309795471) | 8 | 4 | 7 | 28859 | 19 | |||
183604 | 189082 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 320 Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011829.14154 | 2112689.69375 | 37.7817095251229 | -122.402713920937 | (37.7817095251229, -122.402713920937) | 6 | 2 | 9 | 28853 | 34 | |||
183217 | 28142 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 515 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2005 12:00:00 AM | 3 | 3X3 | 6007045.3834675 | 2097893.0996556 | 37.7408132650395 | -122.418214132589 | (37.7408132650395, -122.418214132589) | 2 | 7 | 7 | 28859 | 2 | ||
182793 | 861 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/2013 12:00:00 AM | 3 | 4x4 | 6008036.03862 | 2095018.0701 | 37.7329747750588 | -122.414585408098 | (37.7329747750588, -122.414585408098) | 2 | 7 | 7 | 28859 | 2 | ||
182498 | 96284 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3237 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58767 | 6011926.62111 | 2090638.16357 | 37.7211662664813 | -122.400826962515 | (37.7211662664813, -122.400826962515) | 10 | 7 | 8 | 309 | 28 | |
182457 | 115738 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 95x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776553 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
182365 | 187869 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1600 Indiana St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 6015103.96021 | 2100930.78351 | 37.7496044205169 | -122.390562573713 | (37.7496044205169, -122.390562573713) | 10 | 3 | 8 | 58 | 1 | |||
181942 | 203404 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 155 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5994396.0657 | 2096501.56524 | 37.7362723344984 | -122.461849534529 | (37.7362723344984, -122.461849534529) | 9 | 8 | 4 | 59 | 40 | |||
181572 | 255557 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 100x Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013542 | 2115679 | 37.7900129533755 | -122.396997853926 | (37.7900129533755, -122.396997853926) | 12 | 2 | 9 | 28855 | 6 | ||||
180842 | 140747 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1300x DIVISADERO ST | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001275.0195 | 2113083.841 | 37.7821968322814 | -122.439254386463 | (37.7821968322814, -122.439254386463) | 15 | 5 | 11 | 29490 | 41 | |||
180731 | 189077 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1047 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010192.31636 | 2109010.06883 | 37.7715146098343 | -122.408117004595 | (37.7715146098343, -122.408117004595) | 14 | 2 | 9 | 28853 | 34 | |||
180466 | 220498 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 217 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1972 12:00:00 AM | 8 | Width 3ft | Permit Number 11470 | 6001117.07632 | 2105053.576 | 37.7601387417168 | -122.43922504972 | (37.7601387417168, -122.43922504972) | 2 | 4 | 5 | 28862 | 3 | |
180160 | 24873 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2585 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2015 12:00:00 AM | 5 | 3x3 | 6011029.3172 | 2093570.939 | 37.7291689698102 | -122.404134997931 | (37.7291689698102, -122.404134997931) | 10 | 3 | 7 | 309 | 28 | ||
180115 | 9750 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 688X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/25/2006 12:00:00 AM | 3 | 3x3 | 6005981.3683502 | 2112123.5425617 | 37.7798267784404 | -122.422904237561 | (37.7798267784404, -122.422904237561) | 7 | 9 | 11 | 28852 | 41 | ||
180085 | 14857 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1365 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1992 12:00:00 AM | 3 | 3x3 | 6002635.4903 | 2111607.9304 | 37.7782216761893 | -122.434442215691 | (37.7782216761893, -122.434442215691) | 15 | 5 | 11 | 29492 | 41 | ||
180032 | 187926 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 11 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013589.1856 | 2115211.48481 | 37.788731892112 | -122.396801804765 | (37.788731892112, -122.396801804765) | 12 | 2 | 9 | 28855 | 6 | |||
179843 | 49216 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
179788 | 187861 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1000 22nd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6014851.37518 | 2103923.26798 | 37.7578071306235 | -122.391645226173 | (37.7578071306235, -122.391645226173) | 10 | 3 | 8 | 28856 | 29 | |||
179773 | 220441 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2601 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009797.09758 | 2102115.80725 | 37.7525623968437 | -122.408997567676 | (37.7525623968437, -122.408997567676) | 2 | 4 | 7 | 28859 | 19 | |||
179722 | 8242 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
179705 | 255411 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
179388 | 220462 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1890 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009480.11253 | 2106070.95534 | 37.7634045784729 | -122.410373004307 | (37.7634045784729, -122.410373004307) | 8 | 4 | 7 | 28859 | 19 | |||
179132 | 115753 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 135x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776552 | 5994185.89401 | 2096656.23912 | 37.7366849291808 | -122.46258739592 | (37.7366849291808, -122.46258739592) | 9 | 8 | 4 | 59 | 40 | ||
179049 | 24854 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2442 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2015 12:00:00 AM | 5 | 3x3 | 6010724.9783872 | 2094386.6708818 | 37.7313917885461 | -122.405244548084 | (37.7313917885461, -122.405244548084) | 10 | 3 | 7 | 309 | 28 | ||
178881 | 187889 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1799 Indiana St | 3 | : | Tree | Private 2 | 3 | Width 5ft | 6015203.04299 | 2100298.1861 | 37.7478729368857 | -122.390175750107 | (37.7478729368857, -122.390175750107) | 3 | 8 | 58 | 1 | ||||
178516 | 220411 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1504 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009388.71104 | 2107693.51126 | 37.7678546200096 | -122.410803732829 | (37.7678546200096, -122.410803732829) | 8 | 4 | 7 | 28853 | 19 | |||
178431 | 220458 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1801 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009537.43524 | 2106105.46914 | 37.7635025587051 | -122.410177179658 | (37.7635025587051, -122.410177179658) | 8 | 4 | 8 | 28859 | 19 | |||
178413 | 203410 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993793.04129 | 2102233.18002 | 37.7519751701323 | -122.464350430425 | (37.7519751701323, -122.464350430425) | 1 | 8 | 4 | 29491 | 12 | |||
178102 | 255413 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
177710 | 112594 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1200M Divisadero St | 4 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6001343.2115 | 2112635.4321 | 37.7809694958311 | -122.438986327521 | (37.7809694958311, -122.438986327521) | 15 | 5 | 11 | 29490 | 41 | |||
177362 | 220422 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1601 Bryant St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009459.04708 | 2107423.88753 | 37.7671182389304 | -122.410541405965 | (37.7671182389304, -122.410541405965) | 8 | 4 | 8 | 28853 | 19 | |||
177311 | 115751 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
177290 | 203400 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 34 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993596.06359 | 2097068.49274 | 37.7377828888614 | -122.464656605522 | (37.7377828888614, -122.464656605522) | 1 | 8 | 4 | 59 | 40 | |||
177261 | 189091 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1433 Galvez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6016333.58663 | 2097354.23847 | 37.739852101202 | -122.38606115391 | (37.739852101202, -122.38606115391) | 10 | 3 | 8 | 58 | 1 | |||
176971 | 256553 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 2 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:24:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
176779 | 86687 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 833 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011571.17232 | 2110322.10121 | 37.7751942579517 | -122.403439761046 | (37.7751942579517, -122.403439761046) | 14 | 2 | 9 | 28853 | 34 | ||
176715 | 187873 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1600 Indiana St | 9 | : | Tree | Private 2 | 3 | Width 3ft | 6015126.80958 | 2100859.52415 | 37.7494100248665 | -122.390478580644 | (37.7494100248665, -122.390478580644) | 10 | 3 | 8 | 58 | 1 | |||
176375 | 88169 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011742.09911 | 2112601.7739 | 37.7814632574728 | -122.403008862566 | (37.7814632574728, -122.403008862566) | 6 | 2 | 9 | 28853 | 34 | |
176012 | 189078 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1047 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010207.59565 | 2109022.90661 | 37.7715507149119 | -122.40806505798 | (37.7715507149119, -122.40806505798) | 14 | 2 | 9 | 28853 | 34 | |||
175886 | 2424 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2843 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/27/1994 12:00:00 AM | 3 | 3X3 | 6009873.38674 | 2100822.77631 | 37.7490162935621 | -122.408642536922 | (37.7490162935621, -122.408642536922) | 2 | 4 | 7 | 28859 | 19 | ||
175776 | 256557 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 6 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:44:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
175632 | 88151 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 300X Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270 | 2112782 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | 6 | 2 | 9 | 28856 | 34 | ||
175622 | 92757 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
175588 | 220496 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3953 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003484.16047 | 2101832.5449 | 37.7514289677954 | -122.430808566285 | (37.7514289677954, -122.430808566285) | 2 | 4 | 5 | 28862 | 22 | |||
175063 | 87445 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2413X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3x3 | 5999221.04782 | 2088973.52313 | 37.7158786645875 | -122.444626724129 | (37.7158786645875, -122.444626724129) | 9 | 7 | 6 | 28861 | 25 | |||
173811 | 220425 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1525 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009445.91202 | 2107658.57784 | 37.7677619080162 | -122.410603413314 | (37.7677619080162, -122.410603413314) | 8 | 4 | 8 | 28853 | 19 | |||
173673 | 92758 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
173604 | 137750 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1000x DIVISADERO ST | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001422.0638 | 2112046.2398 | 37.779356209409 | -122.43867130831 | (37.779356209409, -122.43867130831) | 15 | 5 | 11 | 29490 | 41 | |||
172496 | 28285 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1010 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/28/2003 12:00:00 AM | 3 | 3x3 | 6004371.7708 | 2102969.95862 | 37.7546022894831 | -122.427820139789 | (37.7546022894831, -122.427820139789) | 2 | 4 | 5 | 28862 | 22 | ||
172484 | 256197 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
172086 | 247518 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Divisadero St | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001762.8451 | 2109678.405 | 37.7728741096846 | -122.437322810858 | (37.7728741096846, -122.437322810858) | 15 | 5 | 11 | 29492 | 9 | |||
171416 | 189068 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 521 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013786.48532 | 2112440.07138 | 37.7811332089813 | -122.395924887534 | (37.7811332089813, -122.395924887534) | 6 | 2 | 9 | 28856 | 34 | |||
170997 | 141591 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 700x DIVISADERO ST | 7 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6001556.326 | 2111042.9577 | 37.776609086888 | -122.438134950627 | (37.776609086888, -122.438134950627) | 15 | 5 | 11 | 29492 | 10 | |||
170916 | 220428 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1401 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009431.86283 | 2107936.52181 | 37.7685242902996 | -122.410671638589 | (37.7685242902996, -122.410671638589) | 8 | 4 | 8 | 28853 | 19 | |||
170785 | 57791 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/1977 12:00:00 AM | 2 | Permit Number 16718 | 6011755.44922 | 2112615.88032 | 37.7815027359001 | -122.402963669841 | (37.7815027359001, -122.402963669841) | 6 | 2 | 9 | 28853 | 34 | ||
170547 | 220427 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1501 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009439.69021 | 2107723.53455 | 37.7679399153267 | -122.410629521551 | (37.7679399153267, -122.410629521551) | 8 | 4 | 8 | 28853 | 19 | |||
170529 | 187887 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1798 Indiana St | 3 | : | Tree | Private 2 | 3 | Width 5ft | 6015168.3741 | 2100272.0996 | 37.7477993858291 | -122.390293812223 | (37.7477993858291, -122.390293812223) | 3 | 8 | 58 | 1 | ||||
170084 | 220412 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1650 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009419.37169 | 2107143.66771 | 37.766346595437 | -122.410658846644 | (37.766346595437, -122.410658846644) | 8 | 4 | 7 | 28853 | 19 | |||
169897 | 137762 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1000x DIVISADERO ST | 2 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001439.6617 | 2111903.7642 | 37.7789660085719 | -122.438600218498 | (37.7789660085719, -122.438600218498) | 15 | 5 | 11 | 29490 | 41 | |||
169594 | 175140 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 199 Hamilton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6009153.39783 | 2093543.69822 | 37.7289891767022 | -122.41061831061 | (37.7289891767022, -122.41061831061) | 9 | 3 | 7 | 309 | 28 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );