trees
6,344 rows where qSpecies_id = 19 sorted by Fire Prevention Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
719 | 80747 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1111 Munich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6001772.74556 | 2087054.04067 | 37.7107534679609 | -122.435669635744 | (37.7107534679609, -122.435669635744) | 9 | 7 | 6 | 28861 | 5 | |||
1278 | 170724 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 540 San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000352.85514 | 2092916.82872 | 37.7267706040626 | -122.440997412 | (37.7267706040626, -122.440997412) | 9 | 7 | 6 | 28861 | 25 | ||
1407 | 177359 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 282 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003626.27943 | 2092029.25547 | 37.724519425612 | -122.429618004189 | (37.724519425612, -122.429618004189) | 9 | 7 | 6 | 28861 | 5 | |||
2594 | 177351 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 501X San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2020 12:07:00 PM | 3 | Width 3ft | Permit Number 48612 | 6000375.5599 | 2092850.31101 | 37.7265892548896 | -122.440914152761 | (37.7265892548896, -122.440914152761) | 9 | 7 | 6 | 28861 | 25 | |
2840 | 208818 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 204 Acadia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001433.86045 | 2094986.8847 | 37.7325160147058 | -122.437408581945 | (37.7325160147058, -122.437408581945) | 9 | 7 | 5 | 63 | 40 | |||
2943 | 177371 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 49 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003790.41241 | 2094032.67984 | 37.7300296743254 | -122.429193404555 | (37.7300296743254, -122.429193404555) | 9 | 7 | 6 | 28861 | 5 | |||
2992 | 187489 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 700 Velasco Ave | 5 | Front Yard : Yard | Tree | Private 2 | 3 | 6006684.44019 | 2086612.84014 | 37.7098197873211 | -122.418662398253 | (37.7098197873211, -122.418662398253) | 9 | 7 | 8 | 309 | 39 | ||||
3405 | 108544 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 150 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773707 | 6003029.81861 | 2094379.55796 | 37.730939036385 | -122.431847627669 | (37.730939036385, -122.431847627669) | 9 | 7 | 5 | 28861 | 25 |
3414 | 262418 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
4243 | 162646 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
4810 | 262420 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
5270 | 80931 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1111 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6001747.57084 | 2087049.21095 | 37.710738776642 | -122.435756299834 | (37.710738776642, -122.435756299834) | 9 | 7 | 6 | 28861 | 5 | |||
5299 | 262438 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 540 San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000352.85514 | 2092916.82872 | 37.7267706040626 | -122.440997412 | (37.7267706040626, -122.440997412) | 9 | 7 | 6 | 28861 | 25 | ||
5791 | 171860 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 909 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009090.60075 | 2091384.92035 | 37.7230581082272 | -122.410683014136 | (37.7230581082272, -122.410683014136) | 9 | 3 | 7 | 309 | 28 | |||
6733 | 208696 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 235 Bright St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993735.7088 | 2088773.52296 | 37.7150149747485 | -122.463571955684 | (37.7150149747485, -122.463571955684) | 9 | 8 | 6 | 64 | 24 | |||
7077 | 208685 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 61 Margaret Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997050.0175 | 2089737.60379 | 37.7178525273547 | -122.452185875792 | (37.7178525273547, -122.452185875792) | 9 | 8 | 6 | 28861 | 24 | |||
7709 | 177350 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500x San Juan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000388.06795 | 2092890.63875 | 37.7267006979702 | -122.440873804687 | (37.7267006979702, -122.440873804687) | 9 | 7 | 6 | 28861 | 25 | |||
7764 | 251735 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 338 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 02:05:00 PM | 3 | 3x3 | 6002437 | 2086534 | 37.7093632573177 | -122.433336687258 | (37.7093632573177, -122.433336687258) | 9 | 7 | 6 | 28861 | 5 | ||
7812 | 177349 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500x San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000408.55271 | 2092877.8532 | 37.726666758438 | -122.440802072953 | (37.726666758438, -122.440802072953) | 9 | 7 | 6 | 28861 | 25 | |||
7815 | 78721 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 115 Rey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6008722.75942 | 2087395.11673 | 37.7120823080297 | -122.411672802567 | (37.7120823080297, -122.411672802567) | 9 | 7 | 8 | 309 | 39 | |||
7937 | 47337 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 415 Garfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779205 | 5992952.66327787 | 2090462.04360939 | 37.7196060953775 | -122.466401119038 | (37.7196060953775, -122.466401119038) | 9 | 8 | 6 | 64 | 24 | |
7952 | 262419 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
7986 | 180642 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 56 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 6ft | 6001992.8038 | 2087466.28016 | 37.7118978840556 | -122.4349385283 | (37.7118978840556, -122.4349385283) | 9 | 7 | 6 | 28861 | 5 | |||
8191 | 74104 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 189 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6006471.06973 | 2093054.28635 | 37.7274946077702 | -122.419856624186 | (37.7274946077702, -122.419856624186) | 9 | 7 | 7 | 309 | 5 | |||
8426 | 177304 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 10 Ruth St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 2ft | 6001647.41554 | 2091598.69121 | 37.723224945954 | -122.436427860461 | (37.723224945954, -122.436427860461) | 9 | 7 | 6 | 28861 | 25 | |||
9796 | 72145 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 350 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001088.11474 | 2092709.73665 | 37.72624382708 | -122.438440814794 | (37.72624382708, -122.438440814794) | 9 | 7 | 6 | 28861 | 25 | |||
10345 | 177314 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 570 Edinburgh St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 6002705.04854 | 2090582.53455 | 37.7204948470285 | -122.432699277554 | (37.7204948470285, -122.432699277554) | 9 | 7 | 6 | 28861 | 5 | |||
10670 | 258171 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Dartmouth St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6008455.21796 | 2093605.41918 | 37.7291194808141 | -122.413036341511 | (37.7291194808141, -122.413036341511) | 9 | 3 | 7 | 309 | 28 | |||
11765 | 65228 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 736 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 10 | Permit Number 28015 | 6003178.33467 | 2089873.36869 | 37.7185744644174 | -122.431012691703 | (37.7185744644174, -122.431012691703) | 9 | 7 | 6 | 28861 | 5 | |
11909 | 29249 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2600 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/14/2006 12:00:00 AM | 3 | 3x3 | 6010557.0875047 | 2086190.1499449 | 37.7088764405738 | -122.405248002787 | (37.7088764405738, -122.405248002787) | 9 | 7 | 8 | 309 | 39 | ||
11917 | 77997 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 924 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6009714.16253 | 2086968.85209 | 37.7109674364637 | -122.408216166539 | (37.7109674364637, -122.408216166539) | 9 | 7 | 8 | 309 | 39 | |||
13114 | 44440 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 131 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 11 | Permit Number 43772 | 6001589.30817 | 2087293.58304 | 37.7114007774922 | -122.43632076831 | (37.7114007774922, -122.43632076831) | 9 | 7 | 6 | 28861 | 5 | |
14175 | 260509 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 436 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5995686 | 2095271 | 37.7329676771739 | -122.457300730651 | (37.7329676771739, -122.457300730651) | 9 | 7 | 4 | 59 | 40 | ||||
14361 | 79632 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 66 Danton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6002838.60108 | 2094532.20162 | 37.7313473196134 | -122.432519596596 | (37.7313473196134, -122.432519596596) | 9 | 7 | 5 | 28861 | 25 | |||
16600 | 177348 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 91 Delano Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 3ft | 6000539.83976 | 2092848.12332 | 37.7265926030638 | -122.440346087917 | (37.7265926030638, -122.440346087917) | 9 | 7 | 6 | 28861 | 25 | |||
16734 | 177370 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 163 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004449.21488 | 2094058.71032 | 37.7301384212383 | -122.426917695317 | (37.7301384212383, -122.426917695317) | 9 | 7 | 6 | 28861 | 5 | |||
16990 | 261324 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 434 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/09/2013 12:00:00 AM | 3x3 | Permit Number 767522 | 5993810 | 2090074 | 37.7185900537676 | -122.463409493673 | (37.7185900537676, -122.463409493673) | 9 | 8 | 6 | 64 | 24 | ||
17840 | 208668 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 445 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5997785.47347 | 2094084.58469 | 37.7298304223384 | -122.449956862039 | (37.7298304223384, -122.449956862039) | 9 | 7 | 4 | 28861 | 40 | |||
18262 | 47510 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 54X Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2017 12:00:00 AM | 3 | 3x3 | Permit Number 45390 | 6003705.56041 | 2094600.28554 | 37.731583388063 | -122.429527212219 | (37.731583388063, -122.429527212219) | 9 | 7 | 5 | 28861 | 25 | |
18522 | 82382 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 215 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50651 | 6003111.92374 | 2092137.85519 | 37.7247884784945 | -122.431403811356 | (37.7247884784945, -122.431403811356) | 9 | 7 | 6 | 28861 | 5 | |
19479 | 81046 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 35 Laura St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | 5997413.7835 | 2086913.91099 | 37.7101201491898 | -122.450725028737 | (37.7101201491898, -122.450725028737) | 9 | 7 | 6 | 28861 | 25 | |||
19533 | 259217 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 200 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996177 | 2090586 | 37.7201319742324 | -122.455264770625 | (37.7201319742324, -122.455264770625) | 9 | 8 | 6 | 28861 | 24 | |
20095 | 177378 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1432 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006538.38662 | 2093056.41048 | 37.7275042323322 | -122.419624059499 | (37.7275042323322, -122.419624059499) | 9 | 7 | 7 | 309 | 5 | |||
21000 | 177315 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 570 Edinburgh St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6002661.25858 | 2090511.24379 | 37.7202966148776 | -122.432845554988 | (37.7202966148776, -122.432845554988) | 9 | 7 | 6 | 28861 | 5 | |||
21720 | 122796 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 306 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2016 12:00:00 AM | 3 | 3x3 | 6009497.08014 | 2088289.51504 | 37.7145815488228 | -122.4090595839 | (37.7145815488228, -122.4090595839) | 9 | 7 | 8 | 309 | 39 | ||
23862 | 102476 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 760 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
24727 | 109584 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 130 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774182 | 6000387.32114 | 2092667.05411 | 37.7260867433969 | -122.440860354433 | (37.7260867433969, -122.440860354433) | 9 | 7 | 6 | 28861 | 25 |
25034 | 177387 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 248 London St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002510.9349 | 2092286.89371 | 37.7251636252797 | -122.433492001159 | (37.7251636252797, -122.433492001159) | 9 | 7 | 6 | 28861 | 5 | |||
25082 | 43156 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 224 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 8 | Permit Number 46771 | 6006197.4037 | 2092769.42642 | 37.7266970233279 | -122.420782476251 | (37.7266970233279, -122.420782476251) | 9 | 7 | 7 | 309 | 5 | |
25232 | 208624 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 315 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992634.43122 | 2094769.86953 | 37.7314159585703 | -122.467814270923 | (37.7314159585703, -122.467814270923) | 9 | 8 | 4 | 59 | 40 | |||
25277 | 208786 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 53 Hazelwood Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5996584.59086 | 2094022.02255 | 37.7295898545913 | -122.454103910284 | (37.7295898545913, -122.454103910284) | 9 | 7 | 4 | 28861 | 40 | |||
25524 | 208803 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 25 Keystone Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994077.61421 | 2092858.49075 | 37.726251008155 | -122.462686350095 | (37.726251008155, -122.462686350095) | 9 | 8 | 4 | 59 | 40 | |||
27205 | 40405 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 45 Montecito Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1999 12:00:00 AM | Permit Number 41508 | 5996687.37190018 | 2094527.09346306 | 37.7309825514443 | -122.453785045841 | (37.7309825514443, -122.453785045841) | 9 | 7 | 4 | 28861 | 40 | |||
27245 | 80134 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 210 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50650 | 6003088.75659 | 2092187.60623 | 37.7249237707037 | -122.431487447398 | (37.7249237707037, -122.431487447398) | 9 | 7 | 6 | 28861 | 5 | |
27686 | 208660 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 451 Hearst Ave | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 1ft | 5998589.90723 | 2094352.40559 | 37.7306117919987 | -122.447195121356 | (37.7306117919987, -122.447195121356) | 9 | 7 | 4 | 28861 | 40 | |||
27835 | 208627 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 333 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992862.95035 | 2094498.39886 | 37.7306837602479 | -122.467004515066 | (37.7306837602479, -122.467004515066) | 9 | 8 | 4 | 59 | 40 | |||
28227 | 87687 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2610 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6010522.05865 | 2086133.85401 | 37.7087199047792 | -122.405365106141 | (37.7087199047792, -122.405365106141) | 9 | 7 | 8 | 309 | 39 | |||
28492 | 208698 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4130 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5992075.90201 | 2088383.47737 | 37.713848227595 | -122.469280529167 | (37.713848227595, -122.469280529167) | 9 | 8 | 6 | 64 | 24 | |||
28618 | 208686 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 207 Lakeview Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997054.66762 | 2089435.45045 | 37.7170231509855 | -122.452148013432 | (37.7170231509855, -122.452148013432) | 9 | 8 | 6 | 28861 | 24 | |||
29741 | 48723 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 285 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 45984 | 5994715.98123116 | 2090468.92851584 | 37.7197265891744 | -122.460306507178 | (37.7197265891744, -122.460306507178) | 9 | 8 | 6 | 28861 | 24 | ||
29951 | 177309 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 75 Junior Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 6000450.14627 | 2090377.33986 | 37.7198032881811 | -122.440479023892 | (37.7198032881811, -122.440479023892) | 9 | 7 | 6 | 28861 | 25 | |||
30877 | 208830 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 690 Mangels Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5996850.20525 | 2095290.68766 | 37.7330885321145 | -122.453277212967 | (37.7330885321145, -122.453277212967) | 9 | 7 | 4 | 59 | 40 | |||
31313 | 177347 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 106 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003321.33498 | 2094474.0824 | 37.7312151003813 | -122.430846550931 | (37.7312151003813, -122.430846550931) | 9 | 7 | 5 | 28861 | 25 | |||
31404 | 187488 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 700 Velasco Ave | 4 | Front Yard : Yard | Tree | Private 2 | 5 | Width 4ft | 6006708.59512 | 2086603.96966 | 37.7097967907675 | -122.418578285583 | (37.7097967907675, -122.418578285583) | 9 | 7 | 8 | 309 | 39 | |||
31434 | 208676 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 128 De Montfort Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5994899.10198 | 2091911.82595 | 37.7236989723066 | -122.459777988463 | (37.7236989723066, -122.459777988463) | 9 | 8 | 4 | 28861 | 24 | |||
31515 | 69415 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 144 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33520 | 6001498.01524641 | 2087340.50878812 | 37.7115244375894 | -122.436639656352 | (37.7115244375894, -122.436639656352) | 9 | 7 | 6 | 28861 | 5 | ||
32510 | 208649 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 135 El Verano Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5994517.81355 | 2094566.59033 | 37.7309663766882 | -122.461288380971 | (37.7309663766882, -122.461288380971) | 9 | 8 | 4 | 59 | 40 | |||
32989 | 50828 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 79 Kempton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47347 | 5992329.33717846 | 2087607.86910297 | 37.7117332358721 | -122.468348178801 | (37.7117332358721, -122.468348178801) | 9 | 8 | 4 | 64 | 24 | |||
34012 | 177353 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 501X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2005 12:00:00 AM | 7 | Width 3ft | Permit Number 48612 | 6000427.73907 | 2092811.40851 | 37.7264854092518 | -122.440730982474 | (37.7264854092518, -122.440730982474) | 9 | 7 | 6 | 28861 | 25 | |
34197 | 208827 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 494 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | 5998253.80109 | 2095287.46641 | 37.7331600372071 | -122.448424398367 | (37.7331600372071, -122.448424398367) | 9 | 7 | 4 | 59 | 40 | ||||
34244 | 208692 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 599 Arch St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5992715.18147 | 2091115.28005 | 37.7213860176206 | -122.467269473301 | (37.7213860176206, -122.467269473301) | 9 | 8 | 6 | 64 | 24 | |||
34720 | 30801 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 199 Burnside Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1995 12:00:00 AM | Permit Number 34666 | 6001085.22188443 | 2095491.07454236 | 37.7338805765559 | -122.438650020361 | (37.7338805765559, -122.438650020361) | 9 | 7 | 5 | 63 | 40 | |||
35162 | 208626 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 320 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992857.52794 | 2094699.04603 | 37.7312343746584 | -122.467037843048 | (37.7312343746584, -122.467037843048) | 9 | 8 | 4 | 59 | 40 | |||
35432 | 208630 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 80 Westgate Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993258.27449 | 2093585.29002 | 37.7281993983619 | -122.465571519127 | (37.7281993983619, -122.465571519127) | 9 | 8 | 4 | 59 | 40 | |||
35540 | 208816 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 166 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6001550.6502 | 2095223.1861 | 37.7331714828785 | -122.437021724195 | (37.7331714828785, -122.437021724195) | 9 | 7 | 5 | 63 | 40 | |||
36987 | 107055 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 116 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6003293.70067 | 2094464.35217 | 37.7311868176017 | -122.430941393456 | (37.7311868176017, -122.430941393456) | 9 | 7 | 5 | 28861 | 25 | |||
37270 | 177320 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 48 Concord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5999675.46135 | 2087889.84317 | 37.7129290440003 | -122.442978286612 | (37.7129290440003, -122.442978286612) | 9 | 7 | 6 | 28861 | 5 | |||
39879 | 177340 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1705 San Jose Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6001501.14438 | 2094151.47949 | 37.7302260089086 | -122.437116174588 | (37.7302260089086, -122.437116174588) | 9 | 7 | 6 | 28861 | 25 | |||
39985 | 31104 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 15 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 9 | Permit Number 34834 | 5998731.50717 | 2093011.67693 | 37.7269385551605 | -122.446609165391 | (37.7269385551605, -122.446609165391) | 9 | 7 | 4 | 28861 | 40 | |
41320 | 187485 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 700 Velasco Ave | 1 | Front Yard : Yard | Tree | Private 2 | 7 | Width 9ft | 6006777.87289 | 2086579.02758 | 37.7097322050565 | -122.41833708111 | (37.7097322050565, -122.41833708111) | 9 | 7 | 8 | 309 | 39 | |||
42443 | 177310 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 8 Seminole Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5999325.72656 | 2089990.15999 | 37.7186760905062 | -122.444337923973 | (37.7186760905062, -122.444337923973) | 9 | 7 | 6 | 28861 | 25 | |||
42976 | 57886 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 277 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/1977 12:00:00 AM | 1 | Permit Number 16836 | 6004379.80402 | 2091646.50029 | 37.7235111021408 | -122.426985920562 | (37.7235111021408, -122.426985920562) | 9 | 7 | 6 | 28861 | 5 | ||
42977 | 50408 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 98 Delano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47060 | 6000474.19064274 | 2092822.35654564 | 37.7265181152989 | -122.440571186628 | (37.7265181152989, -122.440571186628) | 9 | 7 | 6 | 28861 | 25 | ||
43811 | 67924 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 114 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31637 | 6003732.77751346 | 2095160.51472993 | 37.7331231920536 | -122.429473055103 | (37.7331231920536, -122.429473055103) | 9 | 7 | 5 | 28861 | 25 | ||
44183 | 208645 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 275 Dalewood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5995277.74857 | 2097239.62936 | 37.7383495948616 | -122.458854632046 | (37.7383495948616, -122.458854632046) | 9 | 7 | 4 | 59 | 40 | |||
44310 | 187486 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 700 Velasco Ave | 2 | Front Yard : Yard | Tree | Private 2 | 9 | Width 9ft | 6006768.10436 | 2086582.6135 | 37.7097415013489 | -122.41837109707 | (37.7097415013489, -122.41837109707) | 9 | 7 | 8 | 309 | 39 | |||
44454 | 230137 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 407 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 2ft | 6003442.81538 | 2095204.31355 | 37.7332270322012 | -122.430478655375 | (37.7332270322012, -122.430478655375) | 9 | 7 | 5 | 28861 | 25 | |||
45065 | 208770 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 555 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993231.91455 | 2095014.28546 | 37.7321215468745 | -122.465766427376 | (37.7321215468745, -122.465766427376) | 9 | 8 | 4 | 59 | 40 | |||
45576 | 43166 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 260 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 6 | Permit Number 42975 | 6005659.39367 | 2092475.61169 | 37.7258599334788 | -122.422621492693 | (37.7258599334788, -122.422621492693) | 9 | 7 | 7 | 309 | 5 | |
46038 | 208670 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 763 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5997054.94426 | 2094988.23183 | 37.7322697938091 | -122.452547559745 | (37.7322697938091, -122.452547559745) | 9 | 7 | 4 | 59 | 40 | |||
47996 | 208632 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 230 Westgate Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993583.1193 | 2094320.76219 | 37.7302375553051 | -122.46450190685 | (37.7302375553051, -122.46450190685) | 9 | 8 | 4 | 59 | 40 | |||
48015 | 57805 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 91 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/1977 12:00:00 AM | 11 | Permit Number 16741 | 6000536.04039 | 2092838.24257 | 37.7265652564651 | -122.44035851386 | (37.7265652564651, -122.44035851386) | 9 | 7 | 6 | 28861 | 25 | ||
48188 | 208813 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 190 Stillings Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999509.64392 | 2095791.25518 | 37.7346150449508 | -122.444118814056 | (37.7346150449508, -122.444118814056) | 9 | 7 | 4 | 63 | 40 | |||
48456 | 208814 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 130 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6001590.72469 | 2095366.55133 | 37.7335674085034 | -122.436893435894 | (37.7335674085034, -122.436893435894) | 9 | 7 | 5 | 63 | 40 | |||
48558 | 208664 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 462 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5998358.74509 | 2094413.2873 | 37.7307657478333 | -122.447998662027 | (37.7307657478333, -122.447998662027) | 9 | 7 | 4 | 59 | 40 | ||||
49831 | 177389 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1011 Munich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002499.03249 | 2087613.48874 | 37.7123308167966 | -122.433199373453 | (37.7123308167966, -122.433199373453) | 9 | 7 | 6 | 28861 | 5 | |||
51143 | 104236 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1265 Bosworth St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770727 | 6000365.2 | 2096127.5 | 37.7355870653858 | -122.441184993439 | (37.7355870653858, -122.441184993439) | 9 | 7 | 4 | 63 | 40 | ||||
52268 | 208807 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 465 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5995478.87513 | 2095402.03061 | 37.7333155569589 | -122.458026289878 | (37.7333155569589, -122.458026289878) | 9 | 7 | 4 | 59 | 40 | |||
52931 | 208687 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 395 Byxbee St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5991938.37587 | 2091181.64136 | 37.7215233557961 | -122.469959478655 | (37.7215233557961, -122.469959478655) | 9 | 8 | 6 | 64 | 24 | |||
53014 | 177381 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 424 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008684.93704 | 2093866.04089 | 37.7298479851843 | -122.412260594059 | (37.7298479851843, -122.412260594059) | 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) );