trees
7,157 rows where qSpecies_id = 36 sorted by Longitude 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4820 | 253072 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1350 46th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | 6x10 | Permit Number 780489 | 5981849.66657 | 2105897.22193 | 37.7613399178539 | -122.50592325662 | (37.7613399178539, -122.50592325662) | 1 | 8 | 3 | 56 | 35 | |
31427 | 37076 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1267 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 6 | Permit Number 39678 | 5982408.3748 | 2106484.4364 | 37.7629851116454 | -122.504034448261 | (37.7629851116454, -122.504034448261) | 1 | 8 | 3 | 56 | 35 | |
7666 | 261515 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 622 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 11:20:00 AM | Width 4ft | 5983216.44703 | 2111516.83265 | 37.7768501112803 | -122.501611967936 | (37.7768501112803, -122.501611967936) | 11 | 6 | 2 | 55 | 26 | |||
5843 | 144170 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 634 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2020 11:21:00 AM | 0 | Width 4ft | 5983217.90934 | 2111466.77005 | 37.7767127398322 | -122.501603204921 | (37.7767127398322, -122.501603204921) | 11 | 6 | 2 | 55 | 26 | ||
156883 | 40195 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 547 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1999 12:00:00 AM | 6 | Permit Number 41379 | 5983457.69122 | 2112080.91654 | 37.7784130880263 | -122.500819169437 | (37.7784130880263, -122.500819169437) | 11 | 6 | 2 | 55 | 26 | |
163507 | 117779 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 7550 Geary Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 10ft | 5983517.54679 | 2112515.20398 | 37.7796090288109 | -122.500644231512 | (37.7796090288109, -122.500644231512) | 11 | 6 | 2 | 55 | 26 | |||
46020 | 47428 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 822 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 6 | Permit Number 45339 | 5983574.08653 | 2110178.26286 | 37.7731957851403 | -122.500275818952 | (37.7731957851403, -122.500275818952) | 11 | 6 | 2 | 55 | 26 | |
126673 | 62469 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3425 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/1986 12:00:00 AM | 10 | Permit Number 22639 | 5983887.9414 | 2105603.0938 | 37.7606520894678 | -122.498852099706 | (37.7606520894678, -122.498852099706) | 1 | 8 | 3 | 56 | 35 | ||
76978 | 117768 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 423 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5984050.00239 | 2112962.03206 | 37.7808671328041 | -122.498835286864 | (37.7808671328041, -122.498835286864) | 11 | 6 | 2 | 55 | 26 | |||
41353 | 184318 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1557 39th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5984035.0211 | 2104355.9181 | 37.7572363202023 | -122.498251311671 | (37.7572363202023, -122.498251311671) | 1 | 8 | 3 | 56 | 35 | |||
37900 | 144097 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 790 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Width 4ft | 5984182.54238 | 2110499.30676 | 37.774112974271 | -122.498194837344 | (37.774112974271, -122.498194837344) | 11 | 6 | 2 | 55 | 26 | ||
194124 | 254846 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 790 38th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Width 4ft | 5984182.54238 | 2110499.30676 | 37.774112974271 | -122.498194837344 | (37.774112974271, -122.498194837344) | 11 | 6 | 2 | 55 | 26 | ||
103516 | 63196 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 478 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 12 | Permit Number 23737 | 5984416.50201 | 2112603.40597 | 37.7799039391325 | -122.497540919644 | (37.7799039391325, -122.497540919644) | 11 | 6 | 2 | 55 | 26 | |
188604 | 118065 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 414 36th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5984711.31641 | 2113070.71562 | 37.7812043122816 | -122.496555535147 | (37.7812043122816, -122.496555535147) | 11 | 6 | 2 | 55 | 26 | |||
47703 | 52674 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 470 REVISED 36th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2006 12:00:00 AM | 12 | Permit Number 48754 | 5984724.91084 | 2112700.37427 | 37.7801882586294 | -122.496481169909 | (37.7801882586294, -122.496481169909) | 11 | 6 | 2 | 55 | 26 | ||
53574 | 63199 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 470 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 12 | Permit Number 23740 | 5984724.91084 | 2112700.37427 | 37.7801882586294 | -122.496481169909 | (37.7801882586294, -122.496481169909) | 11 | 6 | 2 | 55 | 26 | |
98910 | 118058 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 478 36th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 5ft | 5984725.63179 | 2112655.31186 | 37.7800645725255 | -122.496475349721 | (37.7800645725255, -122.496475349721) | 11 | 6 | 2 | 55 | 26 | |||
192986 | 118059 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 478 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 5ft | 5984726.55462 | 2112637.2362 | 37.780014996055 | -122.496470823095 | (37.780014996055, -122.496470823095) | 11 | 6 | 2 | 55 | 26 | |||
52178 | 181507 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400 Sunset Blvd | 67 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984877.2478 | 2105497.3399 | 37.7604196957107 | -122.495422787092 | (37.7604196957107, -122.495422787092) | 1 | 8 | 3 | 56 | 35 | |||
83727 | 181392 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500 Sunset Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984896.9779 | 2104568.1208 | 37.7578694740705 | -122.495286022742 | (37.7578694740705, -122.495286022742) | 1 | 8 | 3 | 56 | 35 | |||
143366 | 181394 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984907.5602 | 2104576.4752 | 37.7578930325113 | -122.495250041349 | (37.7578930325113, -122.495250041349) | 1 | 8 | 3 | 56 | 35 | |||
146941 | 185704 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2101 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984910.4508 | 2100497.5253 | 37.7466935274926 | -122.494939292571 | (37.7466935274926, -122.494939292571) | 1 | 8 | 3 | 29491 | 35 | |||
2061 | 187165 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2301 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 0ft | 5984939.6487 | 2099318.7286 | 37.7434585810539 | -122.494751436092 | (37.7434585810539, -122.494751436092) | 1 | 8 | 3 | 29491 | 35 | |||
189004 | 187230 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2401 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984931.9096 | 2098648.6859 | 37.741618371959 | -122.4947288063 | (37.741618371959, -122.4947288063) | 1 | 8 | 3 | 29491 | 35 | |||
181543 | 187229 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2401 Sunset Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984934.769 | 2098656.8556 | 37.7416409711188 | -122.494719521782 | (37.7416409711188, -122.494719521782) | 1 | 8 | 3 | 29491 | 35 | |||
142154 | 187166 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2301 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984954.0932 | 2099317.2472 | 37.7434553590095 | -122.494701382193 | (37.7434553590095, -122.494701382193) | 1 | 8 | 3 | 29491 | 35 | |||
133888 | 187247 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2401 Sunset Blvd | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984940.8963 | 2098476.306 | 37.7411455892764 | -122.494685028149 | (37.7411455892764, -122.494685028149) | 1 | 8 | 3 | 29491 | 35 | |||
4335 | 187271 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2401 Sunset Blvd | 54 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 5 | Width 0ft | 5984941.9801 | 2098338.6223 | 37.7407676103918 | -122.494671132674 | (37.7407676103918, -122.494671132674) | 1 | 8 | 3 | 29491 | 35 | |||
37202 | 187051 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2501 Sunset Blvd | 70 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984993.8369 | 2097637.9998 | 37.7388469245427 | -122.494440200078 | (37.7388469245427, -122.494440200078) | 1 | 8 | 3 | 29491 | 35 | |||
28709 | 187050 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2501 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984995.182 | 2097644.0528 | 37.7388636231768 | -122.494435995495 | (37.7388636231768, -122.494435995495) | 1 | 8 | 3 | 29491 | 35 | |||
56483 | 21346 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2592X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
151890 | 21347 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2592X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
173582 | 21345 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2592X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
175926 | 187384 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Sunset Blvd | 70 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985074.9529 | 2100108.0339 | 37.7456337184099 | -122.494341764001 | (37.7456337184099, -122.494341764001) | 1 | 8 | 3 | 29491 | 35 | |||
133356 | 187322 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985076.4763 | 2099635.9315 | 37.7443375424183 | -122.494301703866 | (37.7443375424183, -122.494301703866) | 1 | 8 | 3 | 29491 | 35 | |||
180513 | 187317 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985079.5233 | 2099619.0042 | 37.7442912429495 | -122.494289920676 | (37.7442912429495, -122.494289920676) | 1 | 8 | 3 | 29491 | 35 | |||
41441 | 187325 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985091.7109 | 2099649.8119 | 37.7443765457606 | -122.494250049505 | (37.7443765457606, -122.494250049505) | 1 | 8 | 3 | 29491 | 35 | |||
174378 | 187326 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5985094.7578 | 2099652.5203 | 37.7443841605942 | -122.494239713708 | (37.7443841605942, -122.494239713708) | 1 | 8 | 3 | 29491 | 35 | |||
96349 | 50244 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1274 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 6 | Permit Number 46949 | 5985245.6795 | 2106544.1944 | 37.7633156319875 | -122.49422573335 | (37.7633156319875, -122.49422573335) | 1 | 8 | 3 | 56 | 35 | |
168019 | 185000 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2701 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985034.7824 | 2096510.0599 | 37.7357522997185 | -122.494215517122 | (37.7357522997185, -122.494215517122) | 1 | 8 | 3 | 29491 | 35 | |||
5723 | 185011 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2701 Sunset Blvd | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985034.3637 | 2096468.1875 | 37.7356373047826 | -122.494213879386 | (37.7356373047826, -122.494213879386) | 1 | 8 | 3 | 29491 | 35 | |||
128779 | 184999 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2701 Sunset Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985036.0386 | 2096516.3408 | 37.7357696189035 | -122.494211636814 | (37.7357696189035, -122.494211636814) | 1 | 8 | 3 | 29491 | 35 | |||
137156 | 185007 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2701 Sunset Blvd | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985036.4573 | 2096492.0548 | 37.7357029605314 | -122.494208399742 | (37.7357029605314, -122.494208399742) | 1 | 8 | 3 | 29491 | 35 | |||
26196 | 185484 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2400 Sunset Blvd | 37 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985117.0889 | 2098499.1184 | 37.7412185372668 | -122.494077507295 | (37.7412185372668, -122.494077507295) | 1 | 8 | 3 | 29491 | 35 | |||
150655 | 89604 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4249X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 01:18:00 PM | 3 | 3x3 | 5985399.83512 | 2111766.33017 | 37.7776631585248 | -122.494077471354 | (37.7776631585248, -122.494077471354) | 11 | 6 | 2 | 55 | 26 | ||
104934 | 185169 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2500 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985175.8564 | 2097713.8919 | 37.7390659548326 | -122.493816461854 | (37.7390659548326, -122.493816461854) | 1 | 8 | 3 | 29491 | 35 | |||
77198 | 185164 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2500 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985178.5125 | 2097683.3461 | 37.7389822396554 | -122.493805028032 | (37.7389822396554, -122.493805028032) | 1 | 8 | 3 | 29491 | 35 | |||
55391 | 186868 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2700 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985166.3388 | 2096363.9443 | 37.7353588027703 | -122.493749918136 | (37.7353588027703, -122.493749918136) | 1 | 8 | 3 | 29491 | 35 | |||
122590 | 186894 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2700 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985197.9699 | 2096565.1913 | 37.7359132239013 | -122.493655383708 | (37.7359132239013, -122.493655383708) | 1 | 8 | 3 | 29491 | 35 | |||
68007 | 119464 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 690 33rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5985706.91731 | 2111215.35341 | 37.7761682973715 | -122.492974588998 | (37.7761682973715, -122.492974588998) | 11 | 6 | 2 | 55 | 26 | |||
57204 | 119463 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 690 33rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5985707.60303 | 2111194.84048 | 37.7761120148174 | -122.492970705587 | (37.7761120148174, -122.492970705587) | 11 | 6 | 2 | 55 | 26 | |||
140590 | 119462 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 690 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5985708.5317 | 2111176.93111 | 37.7760628951039 | -122.492966173591 | (37.7760628951039, -122.492966173591) | 11 | 6 | 2 | 55 | 26 | |||
44522 | 9275 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 6800 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 1 | 8M | 5985741.39506 | 2112508.81899 | 37.7797218001318 | -122.492950621941 | (37.7797218001318, -122.492950621941) | 11 | 6 | 2 | 55 | 26 | ||
174063 | 119310 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3140 Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5985735.31622 | 2111154.39034 | 37.776002570923 | -122.492871859469 | (37.776002570923, -122.492871859469) | 11 | 6 | 2 | 55 | 26 | |||
113324 | 119309 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3140 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5985780.39427 | 2111154.49522 | 37.7760054948731 | -122.492715932595 | (37.7760054948731, -122.492715932595) | 11 | 6 | 2 | 55 | 26 | |||
158304 | 57808 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3140 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1977 12:00:00 AM | 5 | Permit Number 16744 | 5985802.73798 | 2111156.14973 | 37.7760113441782 | -122.492638762807 | (37.7760113441782, -122.492638762807) | 11 | 6 | 2 | 55 | 26 | ||
56823 | 95981 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 6800 Geary Blvd | 2 | Median : | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 1 | 5985845.24387 | 2112512.87778 | 37.7797390169842 | -122.492591667736 | (37.7797390169842, -122.492591667736) | 11 | 6 | 2 | 55 | 26 | |||
59780 | 182623 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1850 34th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985688.7082 | 2102627.708 | 37.7525879572458 | -122.492405036663 | (37.7525879572458, -122.492405036663) | 1 | 8 | 3 | 56 | 35 | |||
47203 | 182622 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1850 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985688.7082 | 2102616.5515 | 37.7525573245488 | -122.492404215168 | (37.7525573245488, -122.492404215168) | 1 | 8 | 3 | 56 | 35 | |||
89570 | 115232 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 523 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775420 | 5985904.5 | 2112316.6 | 37.7792035589465 | -122.49237222008 | (37.7792035589465, -122.49237222008) | 11 | 6 | 2 | 55 | 26 | |||
148645 | 119420 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 523 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5985932.83173 | 2112325.28299 | 37.7792290562827 | -122.492274849892 | (37.7792290562827, -122.492274849892) | 11 | 6 | 2 | 55 | 26 | |||
161287 | 9266 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 6700 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 1 | 8M | 5986118.97919 | 2112523.68041 | 37.7797846793968 | -122.491645506378 | (37.7797846793968, -122.491645506378) | 11 | 6 | 2 | 55 | 26 | ||
115674 | 92242 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1471 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52688 | 5986177.3397 | 2105245.4336 | 37.7598040693601 | -122.490907896162 | (37.7598040693601, -122.490907896162) | 1 | 8 | 3 | 56 | 35 | |
18896 | 44814 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1490 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | 7 | Permit Number 43906 | 5986225.4839 | 2105102.471 | 37.7594143459963 | -122.490730872272 | (37.7594143459963, -122.490730872272) | 1 | 8 | 3 | 56 | 35 | |
27965 | 250752 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2901 Lake St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5986424.93008 | 2114442.00466 | 37.7850697232391 | -122.490728288873 | (37.7850697232391, -122.490728288873) | 11 | 6 | 1 | 55 | 33 | |||
80500 | 250753 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2901 Lake St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5986440.50803 | 2114442.51108 | 37.7850720236993 | -122.490674432088 | (37.7850720236993, -122.490674432088) | 11 | 6 | 1 | 55 | 33 | |||
89331 | 181904 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2370 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5986121.3373 | 2099118.1885 | 37.7429770494421 | -122.490650759358 | (37.7429770494421, -122.490650759358) | 1 | 8 | 3 | 29491 | 35 | |||
156831 | 250754 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2901 Lake St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 5986452.66826 | 2114440.57637 | 37.7850674218586 | -122.490632219704 | (37.7850674218586, -122.490632219704) | 11 | 6 | 1 | 55 | 33 | |||
12419 | 9256 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 6600X Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 2 | 8M | 5986422.80447 | 2112533.30055 | 37.7798288450778 | -122.490595163822 | (37.7798288450778, -122.490595163822) | 11 | 6 | 2 | 55 | 26 | ||
83200 | 250857 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 219 30th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986476.07648 | 2114406.82652 | 37.7849761217939 | -122.490548751849 | (37.7849761217939, -122.490548751849) | 11 | 6 | 1 | 55 | 33 | |||
124792 | 250856 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 219 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5986476.36541 | 2114420.40824 | 37.7850134301615 | -122.490548751835 | (37.7850134301615, -122.490548751835) | 11 | 6 | 1 | 55 | 33 | |||
128825 | 250859 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 219 30th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5986477.24013 | 2114376.00216 | 37.7848915549471 | -122.490542457465 | (37.7848915549471, -122.490542457465) | 11 | 6 | 1 | 55 | 33 | |||
80910 | 250858 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 219 30th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5986477.98376 | 2114389.57454 | 37.7849288642293 | -122.490540883666 | (37.7849288642293, -122.490540883666) | 11 | 6 | 1 | 55 | 33 | |||
48884 | 250860 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 219 30th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5986477.78356 | 2114358.77919 | 37.7848442973726 | -122.490539309842 | (37.7848442973726, -122.490539309842) | 11 | 6 | 1 | 55 | 33 | |||
43582 | 250861 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 219 30th Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5986480.5422 | 2114338.79152 | 37.7847895781165 | -122.490528294956 | (37.7847895781165, -122.490528294956) | 11 | 6 | 1 | 55 | 33 | |||
68978 | 95989 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 369 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767641 | 5986512.57741 | 2113474.91393 | 37.7824194894942 | -122.490353892493 | (37.7824194894942, -122.490353892493) | 11 | 6 | 2 | 55 | 26 |
155642 | 66331 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1221 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | 8 | Permit Number 29450 | 5986429.897 | 2106906.0714 | 37.7643784727426 | -122.490156589457 | (37.7643784727426, -122.490156589457) | 1 | 8 | 3 | 56 | 35 | |
12283 | 69918 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1285 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5986443.4748 | 2106504.0514 | 37.7632754302753 | -122.490080055854 | (37.7632754302753, -122.490080055854) | 1 | 8 | 3 | 56 | 35 | |||
49232 | 33169 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2221 TARAVAL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768560 | 5986287.4 | 2098860 | 37.7422778317635 | -122.490057581406 | (37.7422778317635, -122.490057581406) | 1 | 8 | 3 | 29491 | 35 |
103512 | 95456 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986576.02446 | 2111660.34524 | 37.7774409068096 | -122.490000890521 | (37.7774409068096, -122.490000890521) | 11 | 6 | 2 | 55 | 26 | ||
95348 | 119994 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 526 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5986601.12954 | 2112305.72798 | 37.7792144102456 | -122.489961524542 | (37.7792144102456, -122.489961524542) | 11 | 6 | 2 | 55 | 26 | |||
68321 | 181954 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2213 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5986321.1753 | 2098879.7703 | 37.7423340880066 | -122.48994225214 | (37.7423340880066, -122.48994225214) | 1 | 8 | 3 | 29491 | 35 | |||
120943 | 44807 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1276 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | 8 | Permit Number 43902 | 5986485.3888 | 2106571.9403 | 37.7634642819189 | -122.489940084577 | (37.7634642819189, -122.489940084577) | 1 | 8 | 3 | 56 | 35 | |
73794 | 66335 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1354 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | 4 | Permit Number 29456 | 5986504.5124 | 2106031.2188 | 37.7619807269847 | -122.48983417325 | (37.7619807269847, -122.48983417325) | 1 | 8 | 3 | 56 | 35 | |
27604 | 66340 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1491 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/1990 12:00:00 AM | 7 | Permit Number 29461 | 5986488.9908 | 2105111.6589 | 37.7594549628167 | -122.489820224274 | (37.7594549628167, -122.489820224274) | 1 | 8 | 3 | 56 | 35 | |
54276 | 119546 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 741 30th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5986610.11945 | 2110793.83788 | 37.7750637139542 | -122.489819203556 | (37.7750637139542, -122.489819203556) | 11 | 6 | 2 | 55 | 26 | |||
36152 | 119936 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 6500x Geary Blvd | 7 | Median : Yard | Tree | DPW 1 | 1 | Width 8ft | 5986709.57611 | 2112539.19718 | 37.7798617820891 | -122.489603541423 | (37.7798617820891, -122.489603541423) | 11 | 6 | 2 | 55 | 26 | |||
154417 | 121238 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 283 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 5986785 | 2114050 | 37.7840144179764 | -122.489453742509 | (37.7840144179764, -122.489453742509) | 11 | 6 | 1 | 55 | 33 | |||
123334 | 250891 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 245 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5986795.664 | 2114287.51727 | 37.7846671947676 | -122.489434320064 | (37.7846671947676, -122.489434320064) | 11 | 6 | 1 | 55 | 33 | |||
70788 | 250896 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 253 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5986796.03039 | 2114232.28383 | 37.7845155609892 | -122.489428989766 | (37.7845155609892, -122.489428989766) | 11 | 6 | 1 | 55 | 33 | |||
148500 | 250899 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 261 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5986798.04224 | 2114182.00117 | 37.7843776166842 | -122.489418331001 | (37.7843776166842, -122.489418331001) | 11 | 6 | 1 | 55 | 33 | |||
179092 | 250903 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 269 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 5986799.05425 | 2114139.02615 | 37.7842596786901 | -122.489411668832 | (37.7842596786901, -122.489411668832) | 11 | 6 | 1 | 55 | 33 | |||
76096 | 250909 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 283 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 4ft | 5986801.87237 | 2114054.20987 | 37.7840269620296 | -122.48939568069 | (37.7840269620296, -122.48939568069) | 11 | 6 | 1 | 55 | 33 | |||
155697 | 250911 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 289 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986802.05545 | 2114026.59299 | 37.7839511446853 | -122.489393015987 | (37.7839511446853, -122.489393015987) | 11 | 6 | 1 | 55 | 33 | |||
112032 | 250912 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 295 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5986804.90066 | 2113997.38532 | 37.7838711148908 | -122.489381024423 | (37.7838711148908, -122.489381024423) | 11 | 6 | 1 | 55 | 33 | |||
149220 | 47794 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2590 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2002 12:00:00 AM | 6 | Permit Number 45566 | 5986482.4768 | 2097627.1374 | 37.7389041088914 | -122.489292448824 | (37.7389041088914, -122.489292448824) | 1 | 8 | 3 | 29491 | 35 | |
191610 | 250894 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 250 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986839.6011 | 2114252.83409 | 37.7845745295398 | -122.489279763454 | (37.7845745295398, -122.489279763454) | 11 | 6 | 1 | 55 | 33 | |||
109701 | 250898 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 254 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5986841.38943 | 2114228.25144 | 37.7845071370277 | -122.489271768474 | (37.7845071370277, -122.489271768474) | 11 | 6 | 1 | 55 | 33 | |||
169093 | 250900 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 258 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5986841.97365 | 2114201.39313 | 37.7844334259182 | -122.489267771885 | (37.7844334259182, -122.489267771885) | 11 | 6 | 1 | 55 | 33 | |||
155634 | 250904 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 270 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5986844.37269 | 2114133.07691 | 37.784245989215 | -122.489254447562 | (37.784245989215, -122.489254447562) | 11 | 6 | 1 | 55 | 33 |
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) );