trees
1,914 rows where qSpecies_id = 45 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
146 | 190658 | DPW Maintained 1 | :: 45 | 1461 Fairfax Ave | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6016241.73559 | 2097685.48667 | 37.7407565574799 | -122.386401828788 | (37.7407565574799, -122.386401828788) | 10 | 3 | 8 | 58 | 1 | |||
320 | 228444 | DPW Maintained 1 | :: 45 | 399 Haight St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004268.91864 | 2109406.82097 | 37.7722705538615 | -122.428634644993 | (37.7722705538615, -122.428634644993) | 7 | 9 | 11 | 28852 | 10 | |||
326 | 228441 | DPW Maintained 1 | :: 45 | 419 Haight St | 1 | : | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 6 | Width 3ft | 6004104.36681 | 2109385.12417 | 37.7722016657998 | -122.429202297052 | (37.7722016657998, -122.429202297052) | 7 | 9 | 11 | 29492 | 10 | ||
1289 | 190652 | DPW Maintained 1 | :: 45 | 310 Arkansas St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6012893.9262 | 2105541.86403 | 37.7621425904374 | -122.398528520183 | (37.7621425904374, -122.398528520183) | 10 | 3 | 8 | 28856 | 29 | |||
2464 | 190663 | DPW Maintained 1 | :: 45 | 1360 Fairfax Ave | 5 | : | Tree | Private 2 | 2 | Width 3ft | 6016747.40621 | 2097393.16894 | 37.7399818904553 | -122.384633036796 | (37.7399818904553, -122.384633036796) | 10 | 3 | 8 | 58 | 1 | |||
17409 | 228439 | DPW Maintained 1 | :: 45 | 589 Haight St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6003347.45965 | 2109278.2341 | 37.7718652941806 | -122.431812868891 | (37.7718652941806, -122.431812868891) | 15 | 9 | 11 | 29492 | 10 | |||
18831 | 199650 | DPW Maintained 1 | :: 45 | 0 | 1 | : | Tree | Private 2 | 0 | Width 0ft | 6014963.58685 | 2093280.81794 | 37.7285913984524 | -122.390513521988 | (37.7285913984524, -122.390513521988) | 10 | 3 | 8 | 58 | 1 | |||
20749 | 190655 | DPW Maintained 1 | :: 45 | 354 Arkansas St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6012900.86657 | 2105367.98453 | 37.7616655423506 | -122.398492314369 | (37.7616655423506, -122.398492314369) | 10 | 3 | 8 | 28856 | 29 | |||
27689 | 228438 | DPW Maintained 1 | :: 45 | 597 Haight St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6003321.74278 | 2109274.92244 | 37.7718547433349 | -122.431901588786 | (37.7718547433349, -122.431901588786) | 15 | 9 | 11 | 29492 | 10 | |||
31214 | 199649 | DPW Maintained 1 | :: 45 | 1601 Evans Ave | 22 | : | Tree | Private 2 | 0 | Width 1ft | 6015107.35337 | 2098882.19142 | 37.7439796026678 | -122.390407721252 | (37.7439796026678, -122.390407721252) | 10 | 3 | 8 | 58 | 1 | |||
36523 | 190662 | DPW Maintained 1 | :: 45 | 1498 Fairfax Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6016277.57069 | 2097744.40559 | 37.7409203204163 | -122.386282030116 | (37.7409203204163, -122.386282030116) | 10 | 3 | 8 | 58 | 1 | |||
41954 | 228450 | DPW Maintained 1 | :: 45 | 2701 17th St | 2 | : | Tree | Private 2 | 1 | Width 5ft | 6009278.09164 | 2106368.2886 | 37.7642096605602 | -122.411092735367 | (37.7642096605602, -122.411092735367) | 8 | 4 | 7 | 28859 | 19 | |||
48617 | 228447 | DPW Maintained 1 | :: 45 | 365 Haight St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004400.01174 | 2109424.00964 | 37.7723251679145 | -122.428182407399 | (37.7723251679145, -122.428182407399) | 7 | 9 | 11 | 28852 | 10 | |||
70303 | 190657 | DPW Maintained 1 | :: 45 | 301 Mendell St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6016835.36544 | 2097808.79392 | 37.7411279765664 | -122.38435784694 | (37.7411279765664, -122.38435784694) | 10 | 3 | 8 | 58 | 1 | |||
79518 | 190654 | DPW Maintained 1 | :: 45 | 330 Arkansas St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6012898.89819 | 2105464.44963 | 37.7619303045744 | -122.398505891451 | (37.7619303045744, -122.398505891451) | 10 | 3 | 8 | 28856 | 29 | |||
98915 | 199651 | DPW Maintained 1 | :: 45 | 0 | 37 | : | Tree | Private 2 | 0 | Width 0ft | 6018297.01834 | 2097895.80454 | 37.7414476037323 | -122.379309965799 | (37.7414476037323, -122.379309965799) | 10 | 3 | 8 | 58 | 1 | |||
113799 | 228442 | DPW Maintained 1 | :: 45 | 413 Haight St | 1 | : | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 5 | Width 3ft | 6004129.64861 | 2109389.34953 | 37.7722146987825 | -122.429115146464 | (37.7722146987825, -122.429115146464) | 7 | 9 | 11 | 29492 | 10 | ||
117031 | 228446 | DPW Maintained 1 | :: 45 | 379 Haight St | 1 | : | Tree | Private 2 | 5 | Width 5ft | 6004344.90177 | 2109415.20014 | 37.7722978608825 | -122.428372409862 | (37.7722978608825, -122.428372409862) | 7 | 9 | 11 | 28852 | 10 | |||
124110 | 190653 | DPW Maintained 1 | :: 45 | 320 Arkansas St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6012892.66651 | 2105479.77799 | 37.7619720457008 | -122.398528520179 | (37.7619720457008, -122.398528520179) | 10 | 3 | 8 | 28856 | 29 | |||
126949 | 190660 | DPW Maintained 1 | :: 45 | 1395 Fairfax Ave | 2 | : | Tree | Private 2 | 3 | Width 4ft | 6016617.23425 | 2097405.156 | 37.7400076047554 | -122.385083956852 | (37.7400076047554, -122.385083956852) | 10 | 3 | 8 | 58 | 1 | |||
127885 | 190661 | DPW Maintained 1 | :: 45 | 1400 Fairfax Ave | 12 | : | Tree | Private 2 | 7 | Width 3ft | 6016311.59703 | 2097718.64456 | 37.7408514692121 | -122.386162583062 | (37.7408514692121, -122.386162583062) | 10 | 3 | 8 | 58 | 1 | |||
129732 | 228443 | DPW Maintained 1 | :: 45 | 401 Haight St | 1 | : | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 5 | Width 3ft | 6004157.65728 | 2109393.74469 | 37.7722283522845 | -122.429018575473 | (37.7722283522845, -122.429018575473) | 7 | 9 | 11 | 29492 | 10 | ||
143028 | 228448 | DPW Maintained 1 | :: 45 | 353 Haight St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004452.39919 | 2109432.87501 | 37.7723524740195 | -122.42800182623 | (37.7723524740195, -122.42800182623) | 7 | 9 | 11 | 28852 | 10 | |||
143496 | 190656 | DPW Maintained 1 | :: 45 | 358 Arkansas St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6012906.49923 | 2105280.13182 | 37.7614246319699 | -122.398466668421 | (37.7614246319699, -122.398466668421) | 10 | 3 | 8 | 28856 | 29 | |||
145345 | 228445 | DPW Maintained 1 | :: 45 | 391 Haight St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6004290.10245 | 2109410.45263 | 37.7722817243588 | -122.428561627213 | (37.7722817243588, -122.428561627213) | 7 | 9 | 11 | 28852 | 10 | |||
160788 | 228440 | DPW Maintained 1 | :: 45 | 451 Haight St | 1 | : | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 4 | Width 3ft | 6003980.50091 | 2109366.20592 | 37.7721427080557 | -122.429629410284 | (37.7721427080557, -122.429629410284) | 7 | 9 | 11 | 29492 | 10 | ||
162351 | 228434 | DPW Maintained 1 | :: 45 | 292 Church St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6004130.46793 | 2107245.14017 | 37.7663272663153 | -122.428959412666 | (37.7663272663153, -122.428959412666) | 8 | 4 | 5 | 28862 | 3 | |||
178163 | 228431 | DPW Maintained 1 | :: 45 | 270 Valencia St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6006055.13553 | 2108039.7727 | 37.7686178926417 | -122.422358804308 | (37.7686178926417, -122.422358804308) | 8 | 4 | 5 | 28853 | 19 | |||
178446 | 190659 | DPW Maintained 1 | :: 45 | 1461 Fairfax Ave | 5 | : | Tree | Private 2 | 6 | Width 3ft | 6016267.56187 | 2097668.72921 | 37.740711974479 | -122.386311362403 | (37.740711974479, -122.386311362403) | 10 | 3 | 8 | 58 | 1 | |||
194244 | 228432 | DPW Maintained 1 | :: 45 | 300 Church St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6004140.61494 | 2107068.90552 | 37.7658439427747 | -122.428911750393 | (37.7658439427747, -122.428911750393) | 8 | 4 | 5 | 28862 | 3 | |||
31000 | 104827 | Permitted Site 7 | :: 45 | 4366 26th St | : Cutout | Tree | Private 2 | 3X3 | 6001535.3 | 2100615.2 | 37.7479758185871 | -122.437460780102 | (37.7479758185871, -122.437460780102) | 2 | 4 | 5 | 28862 | 22 | |||||
127177 | 115258 | DPW Maintained 1 | :: 45 | 2150 Jackson St | : Cutout | Landscaping | Private 2 | 01/21/2016 12:00:00 AM | 6x12 | 6003858 | 2116995.5 | 37.7930839063862 | -122.430597643601 | (37.7930839063862, -122.430597643601) | 13 | 9 | 1 | 29490 | 27 | ||||
67079 | 251294 | Property Tree 8 | :: 45 | 7126 Geary Blvd | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5984860 | 2112552 | 37.7797887789018 | -122.496002892522 | (37.7797887789018, -122.496002892522) | 11 | 6 | 2 | 55 | 26 | ||||
229 | 121402 | Undocumented 4 | :: 45 | 346X Duncan St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6004011 | 2099874 | 37.7460810947058 | -122.428847079389 | (37.7460810947058, -122.428847079389) | 2 | 7 | 5 | 63 | 22 | ||||
98201 | 106968 | Property Tree 8 | :: 45 | 351 26th Ave | Back Yard : Yard | Tree | Private 2 | 5987720.26121 | 2113604.44601 | 37.7828456076198 | -122.486185401226 | (37.7828456076198, -122.486185401226) | 11 | 6 | 2 | 55 | 26 | ||||||
141783 | 110320 | Property Tree 8 | :: 45 | 9 Imperial Aly | Back Yard : Yard | Landscaping | Private 2 | 6005040.9 | 2119421.8 | 37.7998128500526 | -122.426677597274 | (37.7998128500526, -122.426677597274) | 13 | 9 | 1 | 57 | 17 | ||||||
179317 | 103673 | Property Tree 8 | :: 45 | 64 Henry St | Back Yard : Yard | Tree | Private 2 | 6003097 | 2107420 | 37.7667488371496 | -122.432546472662 | (37.7667488371496, -122.432546472662) | 15 | 5 | 5 | 28862 | 3 | ||||||
803 | 105089 | Significant Tree 6 | :: 45 | 344 Fulton St | 9 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
6366 | 117001 | DPW Maintained 1 | :: 45 | 1X Bernal Heights Blvd | 1 | Front Yard : Yard | Tree | DPW 1 | |||||||||||||||
8301 | 114726 | Significant Tree 6 | :: 45 | 520 Townsend St | 2 | Front Yard : Yard | Tree | Private 2 | 6012508.1 | 2109575.3 | 37.7731959986981 | -122.400146236912 | (37.7731959986981, -122.400146236912) | 14 | 2 | 9 | 28853 | 34 | |||||
15911 | 105081 | Significant Tree 6 | :: 45 | 344 Fulton St | 1 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
17108 | 105086 | Significant Tree 6 | :: 45 | 344 Fulton St | 6 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
23775 | 108576 | Property Tree 8 | :: 45 | 2479 Diamond St | 1 | Front Yard : Yard | Landscaping | Private 2 | 6002240 | 2097369 | 37.7391025518434 | -122.434791855338 | (37.7391025518434, -122.434791855338) | 2 | 7 | 5 | 63 | 7 | |||||
75459 | 105084 | Significant Tree 6 | :: 45 | 344 Fulton St | 4 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
91093 | 105091 | Significant Tree 6 | :: 45 | 344 Fulton St | 11 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
96682 | 115070 | Significant Tree 6 | :: 45 | 401 DARIEN WAY | 1 | Front Yard : Yard | Tree | Private 2 | 17 | 5992724 | 2094938 | 37.7318827746659 | -122.467516839465 | (37.7318827746659, -122.467516839465) | 9 | 8 | 4 | 59 | 40 | ||||
110899 | 114725 | Significant Tree 6 | :: 45 | 520 Townsend St | 1 | Front Yard : Yard | Tree | Private 2 | 6012508.1 | 2109575.3 | 37.7731959986981 | -122.400146236912 | (37.7731959986981, -122.400146236912) | 14 | 2 | 9 | 28853 | 34 | |||||
119424 | 199648 | DPW Maintained 1 | :: 45 | 420 05th St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Width 3ft | 6012151.63129 | 2111560.33 | 37.7786265538123 | -122.401518854125 | (37.7786265538123, -122.401518854125) | 14 | 2 | 9 | 28856 | 34 | |||
126537 | 105082 | Significant Tree 6 | :: 45 | 344 Fulton St | 2 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
127241 | 104634 | DPW Maintained 1 | :: 45 | 217 Montcalm St | Front Yard : Yard | Landscaping | Private 2 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | |||||
145102 | 105085 | Significant Tree 6 | :: 45 | 344 Fulton St | 5 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
148544 | 104637 | DPW Maintained 1 | :: 45 | 217 Montcalm St | Front Yard : Yard | Landscaping | Private 2 | 16x16 | 6010036 | 2099691 | 37.7459177905176 | -122.408000413375 | (37.7459177905176, -122.408000413375) | 2 | 7 | 7 | 28859 | 2 | |||||
154153 | 105087 | Significant Tree 6 | :: 45 | 344 Fulton St | 7 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
161677 | 105090 | Significant Tree 6 | :: 45 | 344 Fulton St | 10 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
167444 | 105083 | Significant Tree 6 | :: 45 | 344 Fulton St | 3 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
171517 | 104636 | DPW Maintained 1 | :: 45 | 217 Montcalm St | Front Yard : Yard | Landscaping | Private 2 | 16x16 | 6010036 | 2099691 | 37.7459177905176 | -122.408000413375 | (37.7459177905176, -122.408000413375) | 2 | 7 | 7 | 28859 | 2 | |||||
178111 | 104635 | DPW Maintained 1 | :: 45 | 217 Montcalm St | Front Yard : Yard | Landscaping | Private 2 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | |||||
186789 | 105088 | Significant Tree 6 | :: 45 | 344 Fulton St | 8 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
365 | 184621 | DPW Maintained 1 | :: 45 | 3100x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5984373.2194 | 2102928.6488 | 37.7533372599652 | -122.496976365214 | (37.7533372599652, -122.496976365214) | 1 | 8 | 3 | 56 | 35 | |||
7740 | 142745 | DPW Maintained 1 | :: 45 | 700x COLUMBUS AVE | 8 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 6009127.5357 | 2120116.4029 | 37.8019502507169 | -122.412585395041 | (37.8019502507169, -122.412585395041) | 3 | 1 | 10 | 308 | 4 | |||
28186 | 185060 | DPW Maintained 1 | :: 45 | 10x El Mirasol Pl | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5987413.8008 | 2096060.1353 | 37.7346558528299 | -122.485957413668 | (37.7346558528299, -122.485957413668) | 1 | 8 | 3 | 64 | 35 | |||
34000 | 184614 | DPW Maintained 1 | :: 45 | 3600x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5982812.7565 | 2102876.5318 | 37.7531025964328 | -122.502368824356 | (37.7531025964328, -122.502368824356) | 1 | 8 | 3 | 56 | 35 | |||
39172 | 184634 | DPW Maintained 1 | :: 45 | 4100x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5981271.0577 | 2102821.0876 | 37.7528596561113 | -122.507696113948 | (37.7528596561113, -122.507696113948) | 1 | 8 | 3 | 56 | 35 | |||
49806 | 184900 | DPW Maintained 1 | :: 45 | 3100x Noriega St | 2 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5984148.1689 | 2102921.2035 | 37.7533036269678 | -122.497754074885 | (37.7533036269678, -122.497754074885) | 1 | 8 | 3 | 56 | 35 | |||
50710 | 184609 | DPW Maintained 1 | :: 45 | 3400x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5983436.8063 | 2102896.8371 | 37.7531949966988 | -122.500212272852 | (37.7531949966988, -122.500212272852) | 1 | 8 | 3 | 56 | 35 | |||
54916 | 184619 | DPW Maintained 1 | :: 45 | 3000x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5984675.7685 | 2102938.8014 | 37.7533828605842 | -122.495930852185 | (37.7533828605842, -122.495930852185) | 1 | 8 | 3 | 56 | 35 | |||
108361 | 184627 | DPW Maintained 1 | :: 45 | 3300x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5983533.5949 | 2102898.8676 | 37.7532062522999 | -122.499877713808 | (37.7532062522999, -122.499877713808) | 1 | 8 | 3 | 56 | 35 | |||
115574 | 15276 | DPW Maintained 1 | :: 45 | 1563X Mission St | 1 | Median : Cutout | Tree | DPW 1 | 10/28/2016 12:00:00 AM | 3 | Permit Number 777705 | 6007259.77782 | 2109715.95764 | 37.7732881790271 | -122.418310894637 | (37.7732881790271, -122.418310894637) | 8 | 2 | 9 | 28853 | 19 | ||
133535 | 184618 | DPW Maintained 1 | :: 45 | 3900x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5981674.4395 | 2102837.4254 | 37.7529282714167 | -122.506302380507 | (37.7529282714167, -122.506302380507) | 1 | 8 | 3 | 56 | 35 | |||
167367 | 184611 | DPW Maintained 1 | :: 45 | 3800x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5982199.0286 | 2102854.3652 | 37.7530056532342 | -122.504489538097 | (37.7530056532342, -122.504489538097) | 1 | 8 | 3 | 56 | 35 | |||
193016 | 184620 | DPW Maintained 1 | :: 45 | 3000x Noriega St | 2 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5984460.1938 | 2102931.6946 | 37.7533507191048 | -122.496675818993 | (37.7533507191048, -122.496675818993) | 1 | 8 | 3 | 56 | 35 | |||
41043 | 255920 | Permitted Site 7 | :: 45 | 3990 Washington St | 4 | Side Yard : Yard | Tree | Private 2 | 08/03/2018 12:00:00 AM | 3 | 5995569.1162 | 2115494.21463 | 37.7884887239215 | -122.459168714213 | (37.7884887239215, -122.459168714213) | 11 | 6 | 1 | 54 | 31 | |||
150270 | 118550 | Undocumented 4 | :: 45 | 8140 Geary Blvd | 3 | Side Yard : Yard | Tree | Private 2 | 5981686.0706 | 2112397.37669 | 37.7791778206923 | -122.506971243035 | (37.7791778206923, -122.506971243035) | 11 | 6 | 2 | 55 | 26 | |||||
87 | 259654 | DPW Maintained 1 | :: 45 | 101x Cora St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
88 | 259653 | DPW Maintained 1 | :: 45 | 99x Cora St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
89 | 259623 | DPW Maintained 1 | :: 45 | 1498x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
94 | 260654 | Permitted Site 7 | :: 45 | 2590 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3.5x3 | ||||||||||||
103 | 253831 | DPW Maintained 1 | :: 45 | 699X Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | |||||||||||||
113 | 182915 | DPW Maintained 1 | :: 45 | 2711 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981812.2124 | 2096648.8938 | 37.7359443944789 | -122.505367292654 | (37.7359443944789, -122.505367292654) | 1 | 8 | 3 | 29491 | 35 | |||
119 | 184195 | DPW Maintained 1 | :: 45 | 1459 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984624.9154 | 2105245.6219 | 37.759713770345 | -122.49627690204 | (37.759713770345, -122.49627690204) | 1 | 8 | 3 | 56 | 35 | |||
141 | 254165 | DPW Maintained 1 | :: 45 | 579 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5983759 | 2111886 | 37.7778955894485 | -122.499762435435 | (37.7778955894485, -122.499762435435) | 11 | 6 | 2 | 55 | 26 | ||||
144 | 108797 | Undocumented 4 | :: 45 | 501-599 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
149 | 244279 | Undocumented 4 | :: 45 | 585 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004230.7823 | 2110095.842 | 37.7741602789386 | -122.428815691218 | (37.7741602789386, -122.428815691218) | 7 | 9 | 11 | 28852 | 10 | |||
155 | 142339 | DPW Maintained 1 | :: 45 | 516 Central Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5999737.6235 | 2110265.9409 | 37.7743719952599 | -122.444370497086 | (37.7743719952599, -122.444370497086) | 15 | 5 | 11 | 29492 | 16 | |||
165 | 104843 | Permitted Site 7 | :: 45 | 1320 21st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5989622 | 2106334.7 | 37.7629955389606 | -122.479074319647 | (37.7629955389606, -122.479074319647) | 1 | 8 | 3 | 56 | 35 | ||||||
179 | 113995 | DPW Maintained 1 | :: 45 | 3221 Washington St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/27/2015 12:00:00 AM | 39x3 | 5999265.7 | 2115942.6 | 37.789931692457 | -122.446411428366 | (37.789931692457, -122.446411428366) | 13 | 6 | 1 | 29490 | 31 | |||
192 | 137920 | DPW Maintained 1 | :: 45 | 2028 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002940.7431 | 2115305.2702 | 37.7883909617368 | -122.433650548643 | (37.7883909617368, -122.433650548643) | 13 | 9 | 1 | 29490 | 27 | |||
212 | 138278 | DPW Maintained 1 | :: 45 | 2181 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6001737.3169 | 2113910.2795 | 37.7844923181381 | -122.437714255164 | (37.7844923181381, -122.437714255164) | 13 | 6 | 11 | 29490 | 13 | |||
214 | 138888 | DPW Maintained 1 | :: 45 | 675 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004166.2354 | 2110619.5066 | 37.7755944800015 | -122.429076315191 | (37.7755944800015, -122.429076315191) | 7 | 9 | 11 | 28852 | 10 | |||
217 | 105438 | Undocumented 4 | :: 45 | 1116 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002483 | 2102334 | 37.7527490702591 | -122.434306541099 | (37.7527490702591, -122.434306541099) | 2 | 4 | 5 | 28862 | 22 | ||||
224 | 183657 | DPW Maintained 1 | :: 45 | 1490 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981573.7378 | 2104946.7308 | 37.7587138957913 | -122.506807059304 | (37.7587138957913, -122.506807059304) | 1 | 8 | 3 | 56 | 35 | |||
232 | 228435 | DPW Maintained 1 | :: 45 | 178 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004070 | 2107898 | 37.7681164387884 | -122.429215116616 | (37.7681164387884, -122.429215116616) | 7 | 9 | 5 | 28862 | 3 | |||
244 | 200570 | DPW Maintained 1 | :: 45 | 1445 La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6016341.8296 | 2095299.657 | 37.7342110910182 | -122.385889477594 | (37.7342110910182, -122.385889477594) | 10 | 3 | 8 | 58 | 1 | |||
253 | 200884 | DPW Maintained 1 | :: 45 | 1200 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6012817.0471 | 2107089.1245 | 37.7663867409086 | -122.39890301604 | (37.7663867409086, -122.39890301604) | 14 | 3 | 8 | 28856 | 20 | |||
257 | 115298 | Permitted Site 7 | :: 45 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992506.3 | 2098571.2 | 37.7418460572185 | -122.468533715231 | (37.7418460572185, -122.468533715231) | 1 | 8 | 4 | 29491 | 40 | |||||
258 | 139105 | DPW Maintained 1 | :: 45 | 1310 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5999792.0294 | 2113376.32 | 37.7829154028675 | -122.444405875371 | (37.7829154028675, -122.444405875371) | 15 | 6 | 1 | 29490 | 31 | |||
268 | 247892 | DPW Maintained 1 | :: 45 | 1283 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000447.0072 | 2109223.9761 | 37.7715514711219 | -122.441841814274 | (37.7715514711219, -122.441841814274) | 15 | 5 | 11 | 29492 | 9 | |||
276 | 182945 | DPW Maintained 1 | :: 45 | 2691 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981809.5051 | 2096798.8146 | 37.7363558765881 | -122.50538776138 | (37.7363558765881, -122.50538776138) | 1 | 8 | 3 | 29491 | 35 | |||
299 | 116945 | Undocumented 4 | :: 45 | 3676 23RD ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005238 | 2102584 | 37.7535915013127 | -122.424797029407 | (37.7535915013127, -122.424797029407) | 2 | 4 | 5 | 28859 | 19 | ||||
301 | 108803 | Undocumented 4 | :: 45 | 401-499 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 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) );