trees
858 rows where qSpecies_id = 85 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3332 | 259568 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 200 Public Park | 7 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994204 | 2098512 | 37.741781429361 | -122.462659374294 | (37.741781429361, -122.462659374294) | 1 | 8 | 4 | 59 | 40 | ||||
4082 | 215134 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 87 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785257 | 5992831.00569 | 2098575.54206 | 37.741876730518 | -122.467411314403 | (37.741876730518, -122.467411314403) | 1 | 8 | 4 | 59 | 40 | |
19565 | 218219 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 387 Wawona St | 1 | : | Tree | Private 2 | 2 | Width 2ft | 5991861.85445 | 2097038.30782 | 37.7375998777167 | -122.470650352243 | (37.7375998777167, -122.470650352243) | 1 | 8 | 4 | 59 | 40 | |||
24721 | 215166 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 491 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994735.18104 | 2099969.77075 | 37.7458146809981 | -122.460928368863 | (37.7458146809981, -122.460928368863) | 1 | 8 | 4 | 59 | 40 | |||
30492 | 215162 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 50 Sola Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5994831.77603 | 2100788.44228 | 37.7480681050619 | -122.460653675452 | (37.7480681050619, -122.460653675452) | 1 | 8 | 4 | 29491 | 40 | |||
33485 | 215143 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 600 Portola Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5997162.83414 | 2099722.45046 | 37.7452749915648 | -122.452516088848 | (37.7452749915648, -122.452516088848) | 1 | 7 | 4 | 59 | 40 | |||
34040 | 215141 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 600 Portola Dr | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997116.2143 | 2099688.39867 | 37.7451788225419 | -122.452674834471 | (37.7451788225419, -122.452674834471) | 1 | 7 | 4 | 59 | 40 | |||
40405 | 48612 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 201 Ulloa St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45914 | 5996181.58703013 | 2099061.98037763 | 37.7434052350482 | -122.455861320442 | (37.7434052350482, -122.455861320442) | 1 | 5 | 4 | 59 | 40 | ||
50492 | 184002 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1600 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984962.772 | 2103675.8065 | 37.755423278248 | -122.494992688075 | (37.755423278248, -122.494992688075) | 1 | 8 | 3 | 56 | 35 | |||
59868 | 184889 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1201 Sunset Blvd | 78 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984679.4382 | 2106701.786 | 37.7637151826251 | -122.496195774698 | (37.7637151826251, -122.496195774698) | 1 | 8 | 3 | 56 | 35 | |||
66111 | 215135 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 151 Garcia Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994656.8422 | 2099309.30963 | 37.7439967122691 | -122.461151386338 | (37.7439967122691, -122.461151386338) | 1 | 8 | 4 | 59 | 40 | |||
70636 | 33147 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2301 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 1 | Permit Number 37372 | 5987301.0757 | 2099570.9968 | 37.7442891825609 | -122.486604840877 | (37.7442891825609, -122.486604840877) | 1 | 8 | 3 | 29491 | 35 | |
86386 | 186518 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1400 Lower Great Hwy | 4 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5980903.7154 | 2105000.9085 | 37.7588231736816 | -122.509128284969 | (37.7588231736816, -122.509128284969) | 1 | 8 | 3 | 56 | 35 | |||
88234 | 185247 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2563 33rd Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 0ft | 5986114.9152 | 2097795.4761 | 37.7393448594272 | -122.490575670571 | (37.7393448594272, -122.490575670571) | 1 | 8 | 3 | 29491 | 35 | |||
97142 | 215136 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 151 Garcia Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994660.35977 | 2099282.88331 | 37.7439243546336 | -122.461137308351 | (37.7439243546336, -122.461137308351) | 1 | 8 | 4 | 59 | 40 | |||
100019 | 215161 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 50 Sola Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5994838.83006 | 2100785.53894 | 37.7480605390596 | -122.460629072691 | (37.7480605390596, -122.460629072691) | 1 | 8 | 4 | 29491 | 40 | |||
127491 | 215142 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 600 Portola Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5997147.4382 | 2099712.0801 | 37.745245634988 | -122.452568576882 | (37.745245634988, -122.452568576882) | 1 | 7 | 4 | 59 | 40 | |||
151195 | 37083 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1455 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 2 | Permit Number 39684 | 5982141.0737 | 2105203.0053 | 37.7594509451745 | -122.504863975399 | (37.7594509451745, -122.504863975399) | 1 | 8 | 3 | 56 | 35 | |
151244 | 215145 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 600 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5997195.49979 | 2099744.2585 | 37.7453367425973 | -122.452404710507 | (37.7453367425973, -122.452404710507) | 1 | 7 | 4 | 59 | 40 | |||
169439 | 83272 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2567 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50742 | 5982092.0873 | 2097624.9023 | 37.7386407116711 | -122.504471956236 | (37.7386407116711, -122.504471956236) | 1 | 8 | 3 | 29491 | 35 | |
183055 | 215144 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 600 Portola Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5997178.24571 | 2099733.5581 | 37.7453063734035 | -122.452463599922 | (37.7453063734035, -122.452463599922) | 1 | 7 | 4 | 59 | 40 | |||
188602 | 46367 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1525 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2002 12:00:00 AM | 13 | Permit Number 44604 | 5985570.8909 | 2104812.3902 | 37.7585796043104 | -122.49297337574 | (37.7585796043104, -122.49297337574) | 1 | 8 | 3 | 56 | 35 | ||
562 | 18470 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2003 12:00:00 AM | 12 | 3X3 | 6010619.64201 | 2102143.08548 | 37.7526833394657 | -122.406154975289 | (37.7526833394657, -122.406154975289) | 10 | 4 | 8 | 28859 | 19 | ||
623 | 179591 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 46 Bishop St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010887.64563 | 2089644.57166 | 37.7183800597759 | -122.404348520588 | (37.7183800597759, -122.404348520588) | 10 | 7 | 8 | 309 | 39 | |||
2442 | 35339 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 740 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 9 | Permit Number 38804 | 6013014.621 | 2103534.39703 | 37.7566372493387 | -122.397970249845 | (37.7566372493387, -122.397970249845) | 10 | 3 | 8 | 28856 | 29 | |
6527 | 40000 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 14 | Permit Number 41257 | 6019376.91864 | 2094304.02926 | 37.7316447838739 | -122.375327100491 | (37.7316447838739, -122.375327100491) | 10 | 3 | 8 | 58 | 1 | |
8388 | 179624 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6010352.88812 | 2091667.17419 | 37.7239038109035 | -122.406339396551 | (37.7239038109035, -122.406339396551) | 10 | 3 | 7 | 309 | 28 | |||
11327 | 12222 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1543 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/1996 12:00:00 AM | 6 | 3X3 | 6015840.7459 | 2095893.0455 | 37.7358126735457 | -122.387663285334 | (37.7358126735457, -122.387663285334) | 10 | 3 | 8 | 58 | 1 | ||
12811 | 245270 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599X Ogden Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6008504 | 2096098 | 37.7359663084052 | -122.413043870385 | (37.7359663084052, -122.413043870385) | 10 | 7 | 7 | 28859 | 2 | |||
14932 | 51370 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 39 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 47705 | 6013932.28471 | 2095479.44374 | 37.7345711103726 | -122.394232686294 | (37.7345711103726, -122.394232686294) | 10 | 3 | 8 | 58 | 1 |
15296 | 49997 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 400 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014312.2211 | 2105187.35151 | 37.7612480878485 | -122.393598329713 | (37.7612480878485, -122.393598329713) | 10 | 3 | 8 | 28856 | 29 |
16751 | 78587 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1361 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012314.29117 | 2102093.10716 | 37.7526407529845 | -122.400291031321 | (37.7526407529845, -122.400291031321) | 10 | 3 | 8 | 28856 | 29 | |||
16960 | 179590 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 40 Bishop St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010898.94901 | 2089680.08922 | 37.7184782153849 | -122.404311947847 | (37.7184782153849, -122.404311947847) | 10 | 7 | 8 | 309 | 39 | |||
17041 | 197764 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 9 | Median : Yard | Tree | DPW 1 | 14 | Width 8ft | 6015565.1078 | 2103547.12613 | 37.7568139175333 | -122.389150557161 | (37.7568139175333, -122.389150557161) | 10 | 3 | 8 | 28856 | 29 | |||
17588 | 245271 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599X Ogden Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6008504 | 2096098 | 37.7359663084052 | -122.413043870385 | (37.7359663084052, -122.413043870385) | 10 | 7 | 7 | 28859 | 2 | |||
19243 | 197785 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2347 19th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6010748.45807 | 2105046.89477 | 37.7606637578537 | -122.405914042413 | (37.7606637578537, -122.405914042413) | 10 | 3 | 8 | 28856 | 29 | ||||
20212 | 197797 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 315 Topeka Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6013586.21958 | 2094425.53729 | 37.731658057859 | -122.395355352274 | (37.731658057859, -122.395355352274) | 10 | 3 | 8 | 58 | 1 | |||
20782 | 40002 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 8 | Permit Number 41257 | 6019340.13593 | 2094332.72798 | 37.731721560802 | -122.375456255711 | (37.731721560802, -122.375456255711) | 10 | 3 | 8 | 58 | 1 | |
22473 | 37940 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 728 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2003 12:00:00 AM | 12 | Permit Number 46514 | 6015675.91863 | 2103966.98263 | 37.7579728963479 | -122.388796638862 | (37.7579728963479, -122.388796638862) | 10 | 3 | 8 | 28856 | 29 | |
24505 | 179621 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6010365.10231 | 2091621.97451 | 37.7237803852281 | -122.406293990689 | (37.7237803852281, -122.406293990689) | 10 | 3 | 7 | 309 | 28 | |||
25201 | 199699 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2098 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015522.8982 | 2092787.4061 | 37.7272675999797 | -122.388545507017 | (37.7272675999797, -122.388545507017) | 10 | 3 | 8 | 58 | 1 | |||
25868 | 87525 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2600 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x8 | 6011029.3764 | 2093400.1095 | 37.7286999109797 | -122.404122775515 | (37.7286999109797, -122.404122775515) | 10 | 3 | 7 | 309 | 28 | |||
26992 | 179620 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 602 Somerset St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6010330.79398 | 2091554.32638 | 37.7235927183043 | -122.40640782506 | (37.7235927183043, -122.40640782506) | 10 | 3 | 7 | 309 | 28 | |||
27810 | 179583 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 299 Lathrop Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012138.53838 | 2086862.1031 | 37.7108097799129 | -122.399829404828 | (37.7108097799129, -122.399829404828) | 10 | 3 | 8 | 309 | 1 | |||
28707 | 50621 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 820 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2003 12:00:00 AM | Permit Number 47218 | 6019242.65386152 | 2094476.11509562 | 37.7321099088197 | -122.375803212343 | (37.7321099088197, -122.375803212343) | 10 | 3 | 8 | 58 | 1 | |||
30055 | 197791 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 340 Arkansas St | 2 | : | Tree | Private 2 | 14 | Width 3ft | 6012898.99071 | 2105404.50767 | 37.7617657223333 | -122.39850136517 | (37.7617657223333, -122.39850136517) | 10 | 3 | 8 | 28856 | 29 | |||
30083 | 201521 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 869 Innes Ave | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6019420.24762 | 2094273.01088 | 37.7315619976776 | -122.375175152832 | (37.7315619976776, -122.375175152832) | 10 | 3 | 8 | 58 | 1 | |||
33501 | 197788 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2056 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011954.13771 | 2104694.98029 | 37.7597648350875 | -122.401719379549 | (37.7597648350875, -122.401719379549) | 10 | 3 | 8 | 28856 | 29 | |||
33656 | 179619 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 104 Burrows St | 2 | Side Yard : Yard | Tree | Private 2 | 4 | 6011168.71552 | 2093496.29206 | 37.7289717927968 | -122.4036478336 | (37.7289717927968, -122.4036478336) | 10 | 3 | 7 | 309 | 28 | ||||
35261 | 197796 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1938 Quesada Ave | 4 | : | Tree | Private 2 | 11 | Width 2ft | 6013463.04553 | 2095982.9565 | 37.7359275587079 | -122.395890286113 | (37.7359275587079, -122.395890286113) | 10 | 3 | 8 | 58 | 1 | |||
36252 | 197767 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 14 | Median : Yard | Tree | DPW 1 | 14 | Width 8ft | 6015569.44669 | 2103464.91746 | 37.756588430534 | -122.38912981161 | (37.756588430534, -122.38912981161) | 10 | 3 | 8 | 28856 | 29 | |||
41124 | 50008 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 400 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014311.55635 | 2105196.94353 | 37.7612743885122 | -122.393601300174 | (37.7612743885122, -122.393601300174) | 10 | 3 | 8 | 28856 | 29 |
43497 | 197813 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1548 La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015877.12645 | 2095949.17922 | 37.7359688205142 | -122.387541417306 | (37.7359688205142, -122.387541417306) | 10 | 3 | 8 | 58 | 1 | |||
46103 | 39999 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 13 | Permit Number 41257 | 6019347.79521 | 2094325.03679 | 37.7317008637943 | -122.375429242788 | (37.7317008637943, -122.375429242788) | 10 | 3 | 8 | 58 | 1 | |
48581 | 121492 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1809 19th St | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6012288.86366 | 2105128.25072 | 37.760973173204 | -122.400592156703 | (37.760973173204, -122.400592156703) | 10 | 3 | 8 | 28856 | 29 | ||||
50843 | 179585 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 320 Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 1ft | 6010784.99943 | 2090994.75272 | 37.7220816432233 | -122.404798331783 | (37.7220816432233, -122.404798331783) | 10 | 3 | 7 | 309 | 28 | |||
52850 | 197768 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 15 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 6015570.7208 | 2103442.3208 | 37.7565264555391 | -122.389123827518 | (37.7565264555391, -122.389123827518) | 10 | 3 | 8 | 28856 | 29 | |||
53030 | 60578 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 801 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1982 12:00:00 AM | 10 | Permit Number 20192 | 6015478.27896 | 2103906.06329 | 37.7577946687129 | -122.389475912095 | (37.7577946687129, -122.389475912095) | 10 | 3 | 8 | 28856 | 29 | ||
53573 | 93802 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 21 Bishop St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6010948.90983 | 2089721.21702 | 37.7185939356312 | -122.404142145962 | (37.7185939356312, -122.404142145962) | 10 | 7 | 8 | 309 | 39 | ||||
53726 | 197790 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 340 Arkansas St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6012898.48867 | 2105422.76056 | 37.7618158127736 | -122.398504382391 | (37.7618158127736, -122.398504382391) | 10 | 3 | 8 | 28856 | 29 | |||
55216 | 245272 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 59 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6009614.82012 | 2098366.49718 | 37.7422574054489 | -122.409363346253 | (37.7422574054489, -122.409363346253) | 10 | 7 | 7 | 28859 | 2 | |||
57294 | 87534 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2515 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 6010931.8007 | 2093898.1841 | 37.7300620671282 | -122.404495148402 | (37.7300620671282, -122.404495148402) | 10 | 3 | 7 | 309 | 28 | ||||
58437 | 50007 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 400 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014312.7489 | 2105179.47261 | 37.7612264834299 | -122.393595952812 | (37.7612264834299, -122.393595952812) | 10 | 3 | 8 | 28856 | 29 |
61511 | 28704 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3004 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2008 12:00:00 AM | 16 | 3x3 | 6011587.3423 | 2091581.4466 | 37.7237373984555 | -122.402066038858 | (37.7237373984555, -122.402066038858) | 10 | 3 | 7 | 309 | 28 | ||
63418 | 43902 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1938 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2000 12:00:00 AM | 11 | Permit Number 43504 | 6013487.64027 | 2095982.13361 | 37.735926667475 | -122.395805194058 | (37.735926667475, -122.395805194058) | 10 | 3 | 8 | 58 | 1 | ||
64188 | 40003 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 8 | Permit Number 41257 | 6019368.47353 | 2094309.06128 | 37.7316581360927 | -122.375356645916 | (37.7316581360927, -122.375356645916) | 10 | 3 | 8 | 58 | 1 | |
68536 | 197793 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 66 Ceres St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6013832.07065 | 2093815.87712 | 37.7299977259065 | -122.394462716674 | (37.7299977259065, -122.394462716674) | 10 | 3 | 8 | 58 | 1 | |||
70738 | 197763 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1405 Minnesota St | 1 | Back Yard : Yard | Tree | Private 2 | 3 | 6015410.29997 | 2101920.42662 | 37.7523387624307 | -122.389572339186 | (37.7523387624307, -122.389572339186) | 10 | 3 | 8 | 28856 | 1 | ||||
72093 | 96663 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1400X Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6014978.6151 | 2095394.6292 | 37.7343963311622 | -122.390609217071 | (37.7343963311622, -122.390609217071) | 10 | 3 | 8 | 58 | 1 | |||
74104 | 40001 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 12 | Permit Number 41257 | 6019355.96693 | 2094318.55144 | 37.7316835059849 | -122.375400541805 | (37.7316835059849, -122.375400541805) | 10 | 3 | 8 | 58 | 1 | |
76354 | 28703 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3004 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2008 12:00:00 AM | 16 | 3x3 | 6011599.0463446 | 2091533.093888 | 37.7236052850781 | -122.402022182135 | (37.7236052850781, -122.402022182135) | 10 | 3 | 7 | 309 | 28 | ||
78679 | 197783 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1695 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012618.01326 | 2105616.47326 | 37.7623320757988 | -122.399488041942 | (37.7623320757988, -122.399488041942) | 10 | 3 | 8 | 28856 | 29 | |||
79884 | 179581 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 238 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012679.41908 | 2087343.61539 | 37.7121620563027 | -122.397993741039 | (37.7121620563027, -122.397993741039) | 10 | 3 | 8 | 309 | 1 | |||
80390 | 197795 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1938 Quesada Ave | 2 | : | Tree | Private 2 | 9 | Width 2ft | 6013476.07087 | 2095990.32103 | 37.735948504815 | -122.395845767893 | (37.735948504815, -122.395845767893) | 10 | 3 | 8 | 58 | 1 | |||
82759 | 35347 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1141 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2014 12:00:00 AM | 10 | Permit Number 773064 | 6012246.4084 | 2103087.65437 | 37.7553677771151 | -122.400595641589 | (37.7553677771151, -122.400595641589) | 10 | 3 | 8 | 28856 | 29 | |
83846 | 24857 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2500 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/1996 12:00:00 AM | 20 | 3X3 | 6010898.5282 | 2093826.1579 | 37.7298624387628 | -122.404605107856 | (37.7298624387628, -122.404605107856) | 10 | 3 | 7 | 309 | 28 | ||
84176 | 179592 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 Bishop St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010924.14414 | 2089655.49375 | 37.7184120891289 | -122.404223128119 | (37.7184120891289, -122.404223128119) | 10 | 7 | 8 | 309 | 39 | |||
86009 | 40007 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 939 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 19 | Permit Number 41260 | 6019022.80772 | 2094568.61704 | 37.7323517975898 | -122.37656969105 | (37.7323517975898, -122.37656969105) | 10 | 3 | 8 | 58 | 1 | |
86288 | 24937 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2591 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | 16 | 3X3 | 6011042.03793 | 2093526.3228 | 37.7290471738075 | -122.404087882402 | (37.7290471738075, -122.404087882402) | 10 | 3 | 7 | 309 | 28 | ||
88530 | 24912 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3106 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1996 12:00:00 AM | 16 | 2X3 | 6011710.6178 | 2091173.2445 | 37.7226234388506 | -122.401611216966 | (37.7226234388506, -122.401611216966) | 10 | 3 | 7 | 309 | 28 | ||
89282 | 197786 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1361 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012312.79275 | 2102115.82451 | 37.7527030463337 | -122.400297808599 | (37.7527030463337, -122.400297808599) | 10 | 3 | 8 | 28856 | 29 | |||
90512 | 187427 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3199 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6011854.6582 | 2090886.7407 | 37.7218447944319 | -122.40109317658 | (37.7218447944319, -122.40109317658) | 10 | 3 | 7 | 309 | 28 | |||
91407 | 197812 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 958 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6013362.44746 | 2089433.04688 | 37.7179372398964 | -122.395779290899 | (37.7179372398964, -122.395779290899) | 10 | 3 | 8 | 58 | 1 | |||
94598 | 240880 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2318 22nd St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6011232.06922 | 2103723.4899 | 37.7570570177965 | -122.40414829912 | (37.7570570177965, -122.40414829912) | 10 | 4 | 8 | 28859 | 19 | ||||
95311 | 187423 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2591 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6011041.4081 | 2093531.5119 | 37.7290613868014 | -122.404090424829 | (37.7290613868014, -122.404090424829) | 10 | 3 | 7 | 309 | 28 | |||
96402 | 247643 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 632 Banks St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6008488.56377 | 2095899.21998 | 37.7354196351 | -122.413083188644 | (37.7354196351, -122.413083188644) | 10 | 7 | 7 | 28859 | 2 | |||
96742 | 58378 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1020 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2013 12:00:00 AM | 4 | Permit Number 769968 | 6011874.40937 | 2103617.93894 | 37.7568030681131 | -122.401919409461 | (37.7568030681131, -122.401919409461) | 10 | 3 | 8 | 28856 | 29 | ||
97531 | 28700 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2593 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2008 12:00:00 AM | 16 | 3x3 | 6011048.2422 | 2093513.6383 | 37.7290126914729 | -122.404065541323 | (37.7290126914729, -122.404065541323) | 10 | 3 | 7 | 309 | 28 | ||
99768 | 197789 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 519 Texas St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6013841.50507 | 2104663.54923 | 37.7597836741058 | -122.395189656687 | (37.7597836741058, -122.395189656687) | 10 | 3 | 8 | 28856 | 29 | |||
100832 | 197769 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1301 Minnesota St | 54 | Front Yard : Yard | Tree | Private 2 | 7 | 6015357.64937 | 2102415.32545 | 37.7536947305524 | -122.389788979575 | (37.7536947305524, -122.389788979575) | 10 | 3 | 8 | 28856 | 29 | ||||
100870 | 54823 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1438 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 7 | Permit Number 10677 | 6015466.1212 | 2093109.3415 | 37.7281484238722 | -122.388764251275 | (37.7281484238722, -122.388764251275) | 10 | 3 | 8 | 58 | 1 | ||
101290 | 69866 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 42 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52372 | 6018792.25966014 | 2094248.90737336 | 37.7314612388187 | -122.377344581888 | (37.7314612388187, -122.377344581888) | 10 | 3 | 8 | 58 | 1 | ||
103161 | 179627 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6010336.72583 | 2091718.34914 | 37.7240434225456 | -122.406398871428 | (37.7240434225456, -122.406398871428) | 10 | 3 | 7 | 309 | 28 | |||
104595 | 50002 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1101X 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014257.86563 | 2105244.06654 | 37.7614007945303 | -122.393790293612 | (37.7614007945303, -122.393790293612) | 10 | 3 | 8 | 28856 | 29 |
104996 | 179589 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 40 Bishop St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010901.30709 | 2089684.55651 | 37.718490613421 | -122.404304111153 | (37.718490613421, -122.404304111153) | 10 | 7 | 8 | 309 | 39 | |||
105569 | 49744 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 27 Bishop St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 12 | Permit Number 46543 | 6010938.20638 | 2089696.59945 | 37.7185257427455 | -122.404177411982 | (37.7185257427455, -122.404177411982) | 10 | 7 | 8 | 309 | 39 | |
108001 | 35885 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 65 Elmira St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 3 | Permit Number 39085 | 6011186.47786 | 2096510.21791 | 37.7372483911964 | -122.403798418789 | (37.7372483911964, -122.403798418789) | 10 | 3 | 8 | 58 | 1 | |
108105 | 49999 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1101X 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014232.027 | 2105242.25356 | 37.7613943805613 | -122.393879532433 | (37.7613943805613, -122.393879532433) | 10 | 3 | 8 | 28856 | 29 |
109214 | 240881 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2318 22nd St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6011232.67405 | 2103729.80119 | 37.7570743809943 | -122.404146651544 | (37.7570743809943, -122.404146651544) | 10 | 4 | 8 | 28859 | 19 | |||
109417 | 87526 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2602 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x8 | 6011024.729699 | 2093421.52877 | 37.7287584641902 | -122.40414034637 | (37.7287584641902, -122.40414034637) | 10 | 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) );