trees
11,635 rows where qSpecies_id = 27 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13007 | 23212 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 595X Van Ness Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6006669.9178 | 2112533.82047 | 37.7809921295165 | -122.420551368612 | (37.7809921295165, -122.420551368612) | 7 | 9 | 11 | 28852 | 41 | |||
| 13756 | 261045 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 750 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006673 | 2113065 | 37.7824507928685 | -122.420578423098 | (37.7824507928685, -122.420578423098) | 7 | 9 | 9 | 28852 | 36 | ||||
| 14103 | 138820 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 745 BUCHANAN ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 0ft | 6004444.1581 | 2111151.4533 | 37.7770708033891 | -122.428152830639 | (37.7770708033891, -122.428152830639) | 7 | 9 | 11 | 28852 | 10 | |||
| 14331 | 13971 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1150X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6008925.3091 | 2112314.2981 | 37.780516220741 | -122.412733301341 | (37.780516220741, -122.412733301341) | 7 | 2 | 9 | 28852 | 36 | |||
| 14760 | 14019 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1202X Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008302.0435949 | 2111690.8561203 | 37.7787693964066 | -122.414845342067 | (37.7787693964066, -122.414845342067) | 7 | 2 | 9 | 28852 | 36 | |||
| 15078 | 134475 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Larkin St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6007841.91401 | 2111705.3634 | 37.7787833650015 | -122.416438142805 | (37.7787833650015, -122.416438142805) | 7 | 9 | 9 | 28852 | 36 | |||
| 15238 | 261049 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 770 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006693 | 2113137 | 37.7826496144307 | -122.420514344125 | (37.7826496144307, -122.420514344125) | 7 | 9 | 9 | 28852 | 36 | ||||
| 15880 | 13817 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 954 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6009970.251578 | 2113291.7135456 | 37.7832585661446 | -122.409187326391 | (37.7832585661446, -122.409187326391) | 14 | 2 | 9 | 28852 | 36 | |||
| 16120 | 25725 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 729 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004286.7153 | 2111148.1106 | 37.7770527158877 | -122.428697236196 | (37.7770527158877, -122.428697236196) | 7 | 9 | 11 | 28852 | 10 | |||
| 16861 | 142798 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 699X Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6007067.2377 | 2113220.8814 | 37.7829010154819 | -122.419225590994 | (37.7829010154819, -122.419225590994) | 7 | 9 | 9 | 28852 | 36 | |||
| 17364 | 58719 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 644 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1979 12:00:00 AM | 13 | Permit Number 17953 | 6004754.41778 | 2110912.44898 | 37.7764321054866 | -122.42706251763 | (37.7764321054866, -122.42706251763) | 7 | 9 | 11 | 28852 | 10 | ||
| 17480 | 70938 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 740 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6004494.5748 | 2111134.0934 | 37.777025989784 | -122.427977186119 | (37.777025989784, -122.427977186119) | 7 | 9 | 11 | 28852 | 10 | |||
| 17560 | 142025 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 644 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004734.0318 | 2111258.0307 | 37.7773798353923 | -122.427157659722 | (37.7773798353923, -122.427157659722) | 7 | 9 | 11 | 28852 | 10 | |||
| 17609 | 143316 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 988 MARKET ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009701.8736 | 2113022.474 | 37.7825042594182 | -122.410096796812 | (37.7825042594182, -122.410096796812) | 14 | 2 | 9 | 28852 | 36 | |||
| 17809 | 14069 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1390 Market St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6007575.3554 | 2111000.5411 | 37.7768330981624 | -122.417310315452 | (37.7768330981624, -122.417310315452) | 7 | 2 | 9 | 28852 | 36 | |||
| 18171 | 260058 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Larkin St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 3ft | 6007818.52804 | 2111871.98583 | 37.7792395550969 | -122.416530850318 | (37.7792395550969, -122.416530850318) | 7 | 9 | 9 | 28852 | 36 | ||||
| 18428 | 261048 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 770 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006693 | 2113137 | 37.7826496144307 | -122.420514344125 | (37.7826496144307, -122.420514344125) | 7 | 9 | 9 | 28852 | 36 | ||||
| 18919 | 143287 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1108 MARKET ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009089.4951 | 2112420.8881 | 37.7808181054052 | -122.412172837643 | (37.7808181054052, -122.412172837643) | 7 | 2 | 9 | 28852 | 36 | |||
| 19299 | 143322 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1150 MARKET ST | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6008834.8011 | 2112261.9381 | 37.7803673723101 | -122.413042709121 | (37.7803673723101, -122.413042709121) | 7 | 10 | 9 | 28852 | 36 | |||
| 19796 | 9959 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 199 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6006863.679918 | 2111512.223478 | 37.7781979892315 | -122.419808536864 | (37.7781979892315, -122.419808536864) | 7 | 9 | 9 | 28852 | 36 | |||
| 19992 | 8017 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 450 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | 7 | 9 | 11 | 28852 | 41 | |||
| 20032 | 7756 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 401X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006341.44187 | 2111464.67098 | 37.7780379877234 | -122.421611773646 | (37.7780379877234, -122.421611773646) | 7 | 9 | 11 | 28852 | 10 | |||
| 20351 | 13932 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008956.4875906 | 2112317.4497791 | 37.7805266244044 | -122.412625662667 | (37.7805266244044, -122.412625662667) | 7 | 2 | 9 | 28852 | 36 | |||
| 20437 | 134433 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 421 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6007185.19723 | 2112409.36212 | 37.7806794227666 | -122.418759928834 | (37.7806794227666, -122.418759928834) | 7 | 9 | 9 | 28852 | 36 | |||
| 20789 | 143307 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1066 MARKET ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6009397.1568 | 2112755.81 | 37.7817549795995 | -122.411132146502 | (37.7817549795995, -122.411132146502) | 14 | 2 | 9 | 28852 | 36 | |||
| 20791 | 134336 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1020 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009521.57801 | 2112860.58064 | 37.7820496316232 | -122.41070910705 | (37.7820496316232, -122.41070910705) | 14 | 2 | 9 | 28852 | 36 | |||
| 20917 | 34856 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.7776435713687 | -122.416171839707 | (37.7776435713687, -122.416171839707) | 7 | 2 | 9 | 28852 | 36 | |||||
| 21257 | 142034 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 694 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004512.7848 | 2111226.9077 | 37.7772818652476 | -122.427920807345 | (37.7772818652476, -122.427920807345) | 7 | 9 | 11 | 28852 | 10 | |||
| 21309 | 23168 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2018 12:00:00 AM | 3 | 3X3 | 6006933.38405 | 2111260.68165 | 37.7775112424939 | -122.419549553376 | (37.7775112424939, -122.419549553376) | 7 | 9 | 9 | 28852 | 36 | ||
| 21859 | 98725 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 14 | 3x3 | 6006216.75471 | 2111460.37935 | 37.7780191723707 | -122.422042806835 | (37.7780191723707, -122.422042806835) | 7 | 9 | 11 | 28852 | 10 | |||
| 21930 | 134583 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 Hayes St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006490.56082 | 2111152.12178 | 37.7771882104989 | -122.421073719004 | (37.7771882104989, -122.421073719004) | 7 | 9 | 11 | 28852 | 10 | |||
| 21994 | 7749 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 400X Franklin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3X3 | 6006371.15759 | 2111615.24839 | 37.7784531123456 | -122.421519673008 | (37.7784531123456, -122.421519673008) | 7 | 9 | 11 | 28852 | 10 | |||
| 22057 | 23256 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 750 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6006688.04438 | 2112998.51506 | 37.782269089277 | -122.420521655181 | (37.782269089277, -122.420521655181) | 7 | 9 | 9 | 28852 | 36 | |||
| 22109 | 142799 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 695 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6007073.4205 | 2113178.6928 | 37.782785524045 | -122.419201207424 | (37.782785524045, -122.419201207424) | 7 | 9 | 9 | 28852 | 36 | |||
| 22289 | 250265 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 43 United Nations Plz | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 0ft | 6008543.69421 | 2112166.29735 | 37.7800884197775 | -122.414043018878 | (37.7800884197775, -122.414043018878) | 7 | 10 | 9 | 28852 | 36 | |||
| 23014 | 142242 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 508 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004911.0072 | 2110746.7678 | 37.7759860389318 | -122.426509030142 | (37.7759860389318, -122.426509030142) | 7 | 9 | 11 | 28852 | 10 | |||
| 23363 | 7816 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 725X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006180.4164359 | 2112609.8884573 | 37.7811733949931 | -122.422250204818 | (37.7811733949931, -122.422250204818) | 7 | 9 | 11 | 28852 | 41 | |||
| 23433 | 143407 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1200 MARKET ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6008254.579 | 2111652.4984 | 37.778661408164 | -122.415006825521 | (37.778661408164, -122.415006825521) | 7 | 2 | 9 | 28852 | 36 | |||
| 23476 | 250248 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 39 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6008650.87616 | 2112422.51238 | 37.780797944412 | -122.413690354248 | (37.780797944412, -122.413690354248) | 7 | 10 | 9 | 28852 | 36 | |||
| 23677 | 13833 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 970 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6009828.1026 | 2113177.7906 | 37.7829377961915 | -122.409671063579 | (37.7829377961915, -122.409671063579) | 14 | 2 | 9 | 28852 | 36 | |||
| 23806 | 108427 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 270X HAYES ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006095.6 | 2111028.7 | 37.7768270516853 | -122.422431244298 | (37.7768270516853, -122.422431244298) | 7 | 9 | 11 | 28852 | 10 | ||||
| 23865 | 134503 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Fulton St | 2 | Side Yard : Yard | Tree | Private 2 | 3 | Width 4ft | 6008163.02923 | 2112130.27379 | 37.7799681201757 | -122.415357364558 | (37.7799681201757, -122.415357364558) | 7 | 10 | 9 | 28852 | 36 | |||
| 23951 | 143290 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 942 MARKET ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010113.8089 | 2113443.9586 | 37.7836846363903 | -122.408701417073 | (37.7836846363903, -122.408701417073) | 14 | 2 | 9 | 28852 | 36 | |||
| 24103 | 13931 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6008956.4875906 | 2112317.4497791 | 37.7805266244044 | -122.412625662667 | (37.7805266244044, -122.412625662667) | 7 | 2 | 9 | 28852 | 36 | |||
| 24197 | 200971 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1408 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | Width 0ft | Permit Number 779898 | 6007408.8361 | 2110843.7597 | 37.7763932439775 | -122.417875241075 | (37.7763932439775, -122.417875241075) | 7 | 2 | 9 | 28852 | 36 | ||
| 24266 | 250290 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2 United Nations Plz | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 0ft | 6008327.51503 | 2112020.97203 | 37.7796772470476 | -122.414780595146 | (37.7796772470476, -122.414780595146) | 7 | 10 | 9 | 28852 | 36 | |||
| 24381 | 13937 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1140X Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6008690.2869843 | 2112068.9420038 | 37.7798293375501 | -122.413528998881 | (37.7798293375501, -122.413528998881) | 7 | 2 | 9 | 28852 | 36 | |||
| 24595 | 142021 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 612 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004814.1307 | 2111270.1465 | 37.777417631688 | -122.426881434389 | (37.777417631688, -122.426881434389) | 7 | 9 | 11 | 28852 | 10 | |||
| 24825 | 134411 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 711 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6006180.055 | 2112612.54208 | 37.7811806608057 | -122.422251643798 | (37.7811806608057, -122.422251643798) | 7 | 9 | 11 | 28852 | 41 | |||
| 24947 | 134409 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 745 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006170.74657 | 2112698.79652 | 37.7814169693665 | -122.422289976522 | (37.7814169693665, -122.422289976522) | 7 | 9 | 11 | 28852 | 41 | |||
| 25215 | 117234 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 635 GROVE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004711 | 2111132 | 37.7770324835269 | -122.427228354699 | (37.7770324835269, -122.427228354699) | 7 | 9 | 11 | 28852 | 10 | ||||
| 25854 | 134453 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 320 McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6007366.61168 | 2112317.41393 | 37.7804371678793 | -122.418125806965 | (37.7804371678793, -122.418125806965) | 7 | 9 | 9 | 28852 | 36 | |||
| 25923 | 13977 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1150X Market St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008909.6011 | 2112263.4341 | 37.7803756786583 | -122.412784045926 | (37.7803756786583, -122.412784045926) | 7 | 2 | 9 | 28852 | 36 | |||
| 25998 | 250252 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 39 Leavenworth St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008657.56337 | 2112362.39223 | 37.7806332443579 | -122.4136629663 | (37.7806332443579, -122.4136629663) | 7 | 10 | 9 | 28852 | 36 | |||
| 26090 | 257938 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 745 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004229 | 2111115 | 37.7769585357468 | -122.428894530287 | (37.7769585357468, -122.428894530287) | 7 | 9 | 11 | 28852 | 10 | ||||
| 26125 | 14106 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1540 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6006790.77752 | 2110263.73254 | 37.7747658263044 | -122.419972113338 | (37.7747658263044, -122.419972113338) | 7 | 2 | 11 | 28852 | 10 | |||
| 26152 | 13812 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 950 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 4x4 | 6009942.8788 | 2113250.7921 | 37.7831446720327 | -122.409279136989 | (37.7831446720327, -122.409279136989) | 14 | 2 | 9 | 28852 | 36 | |||
| 26257 | 250305 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 4 United Nations Plz | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 0ft | 6008554.56675 | 2112065.48853 | 37.7798122334727 | -122.413998272207 | (37.7798122334727, -122.413998272207) | 7 | 10 | 9 | 28852 | 36 | |||
| 26261 | 142031 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 674 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004575.0125 | 2111235.7373 | 37.7773096293432 | -122.42770617086 | (37.7773096293432, -122.42770617086) | 7 | 9 | 11 | 28852 | 10 | |||
| 26275 | 88658 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 716 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51635 | 6004376.9691 | 2110859.9669 | 37.7762666516219 | -122.42836447811 | (37.7762666516219, -122.42836447811) | 7 | 9 | 11 | 28852 | 10 | |
| 26358 | 248286 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1550 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6006746.10831 | 2110220.78813 | 37.7746453945164 | -122.420123585239 | (37.7746453945164, -122.420123585239) | 7 | 2 | 11 | 28852 | 10 | |||
| 26500 | 44017 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2000 12:00:00 AM | 5 | Permit Number 43560 | 6007890.74109 | 2112737.11749 | 37.7816190596199 | -122.416342328131 | (37.7816190596199, -122.416342328131) | 7 | 10 | 9 | 28852 | 36 | ||
| 26586 | 14014 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1182 Market St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008422.9969773 | 2111813.5953915 | 37.779113204674 | -122.414435602791 | (37.779113204674, -122.414435602791) | 7 | 2 | 9 | 28852 | 36 | |||
| 26677 | 23208 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 595X Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6006669.9178 | 2112533.82047 | 37.7809921295165 | -122.420551368612 | (37.7809921295165, -122.420551368612) | 7 | 9 | 11 | 28852 | 41 | |||
| 26779 | 14066 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1390 Market St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6007645.4688 | 2111067.7331 | 37.7770215357502 | -122.417072533537 | (37.7770215357502, -122.417072533537) | 7 | 2 | 9 | 28852 | 36 | |||
| 26896 | 134380 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 155 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009030.04741 | 2113102.22412 | 37.7826855557288 | -122.412426670978 | (37.7826855557288, -122.412426670978) | 7 | 10 | 9 | 28852 | 36 | |||
| 27141 | 23210 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 595X Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6006669.9178 | 2112533.82047 | 37.7809921295165 | -122.420551368612 | (37.7809921295165, -122.420551368612) | 7 | 9 | 11 | 28852 | 41 | |||
| 27282 | 13798 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 934 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4X4 | 6010191.6110746 | 2113503.1827139 | 37.7838516090405 | -122.408436428733 | (37.7838516090405, -122.408436428733) | 14 | 2 | 9 | 28852 | 36 | |||
| 27283 | 13981 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1150X Market St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6008866.9651 | 2112266.4261 | 37.7803815007944 | -122.412931755866 | (37.7803815007944, -122.412931755866) | 7 | 2 | 9 | 28852 | 36 | |||
| 27305 | 235465 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 8 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004863.47071 | 2108511.21654 | 37.7698450706158 | -122.426514252247 | (37.7698450706158, -122.426514252247) | 7 | 9 | 5 | 28852 | 10 | |||
| 27320 | 134494 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 40 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008299.31675 | 2112014.9634 | 37.7796591643693 | -122.414877720157 | (37.7796591643693, -122.414877720157) | 7 | 10 | 9 | 28852 | 36 | |||
| 27480 | 235468 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 390 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004708.28694 | 2109863.98523 | 37.7735506713693 | -122.427147399243 | (37.7735506713693, -122.427147399243) | 7 | 9 | 11 | 28852 | 10 | |||
| 27548 | 143288 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 900 MARKET ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010158.2523 | 2113461.736 | 37.7837359380247 | -122.408548913535 | (37.7837359380247, -122.408548913535) | 14 | 2 | 9 | 28852 | 36 | |||
| 27963 | 6943 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 555 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004781.50031 | 2110514.34601 | 37.7753405434717 | -122.426940471548 | (37.7753405434717, -122.426940471548) | 7 | 9 | 11 | 28852 | 10 | |||
| 28099 | 13844 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 984 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6009734.6170855 | 2113066.6079832 | 37.7826272760546 | -122.409986634697 | (37.7826272760546, -122.409986634697) | 14 | 2 | 9 | 28852 | 36 | |||
| 28263 | 13945 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/24/2000 12:00:00 AM | 12 | 4x4 | 6009115.3446 | 2112460.3733 | 37.7809279727613 | -122.412086202614 | (37.7809279727613, -122.412086202614) | 7 | 2 | 9 | 28852 | 36 | ||
| 28290 | 139260 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 780 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6004081.0178 | 2111161.4163 | 37.7770776063948 | -122.429409757006 | (37.7770776063948, -122.429409757006) | 7 | 9 | 11 | 28852 | 10 | |||
| 28344 | 250281 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 43 United Nations Plz | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 0ft | 6008344.09456 | 2112135.76616 | 37.7799933758261 | -122.414731365385 | (37.7799933758261, -122.414731365385) | 7 | 10 | 9 | 28852 | 36 | |||
| 28625 | 25721 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 759 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004181.0849 | 2111131.7312 | 37.7770017633365 | -122.429061476555 | (37.7770017633365, -122.429061476555) | 7 | 9 | 11 | 28852 | 10 | |||
| 28750 | 143409 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1200 MARKET ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008219.5223 | 2111617.4417 | 37.7785631808079 | -122.415125618452 | (37.7785631808079, -122.415125618452) | 7 | 2 | 9 | 28852 | 36 | |||
| 29028 | 13939 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1140X Market St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6008690.2869843 | 2112068.9420038 | 37.7798293375501 | -122.413528998881 | (37.7798293375501, -122.413528998881) | 7 | 2 | 9 | 28852 | 36 | |||
| 29251 | 134346 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1028 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009374.43477 | 2112729.62877 | 37.7816818178938 | -122.411208904374 | (37.7816818178938, -122.411208904374) | 14 | 2 | 9 | 28852 | 36 | |||
| 29261 | 254339 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6009459 | 2112856 | 37.7820335454833 | -122.410925275692 | (37.7820335454833, -122.410925275692) | 14 | 10 | 9 | 28852 | 36 | ||||
| 29545 | 96039 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 890X Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010502.34643 | 2113775.23148 | 37.7846159870569 | -122.407380580095 | (37.7846159870569, -122.407380580095) | 14 | 2 | 10 | 28852 | 6 | |||
| 29612 | 119287 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 400 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2016 12:00:00 AM | 3 | 4x4 | 6005873 | 2111410 | 37.7778614491402 | -122.423228396467 | (37.7778614491402, -122.423228396467) | 7 | 9 | 11 | 28852 | 10 | ||
| 29660 | 248287 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1550 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6006723.04064 | 2110201.25458 | 37.774590460325 | -122.420201994445 | (37.774590460325, -122.420201994445) | 7 | 2 | 11 | 28852 | 10 | |||
| 29933 | 98726 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 12 | 3x3 | 6006198.51355 | 2111464.4034 | 37.7780291926159 | -122.422106195562 | (37.7780291926159, -122.422106195562) | 7 | 9 | 11 | 28852 | 10 | |||
| 30015 | 142019 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 610 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6004857.8822 | 2111274.1851 | 37.777431194396 | -122.426730371163 | (37.777431194396, -122.426730371163) | 7 | 9 | 11 | 28852 | 10 | |||
| 30273 | 249420 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 711 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006894.14828 | 2113241.60882 | 37.7829481784652 | -122.419825880867 | (37.7829481784652, -122.419825880867) | 7 | 9 | 9 | 28852 | 36 | |||
| 30473 | 109556 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300x Van Ness Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6006837.67499 | 2111950.4922 | 37.7793999042174 | -122.419929605965 | (37.7793999042174, -122.419929605965) | 7 | 9 | 9 | 28852 | 36 | |||
| 30480 | 254332 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6009459 | 2112856 | 37.7820335454833 | -122.410925275692 | (37.7820335454833, -122.410925275692) | 14 | 10 | 9 | 28852 | 36 | ||||
| 30500 | 138959 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 680 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004593.0807 | 2110896.8397 | 37.7763801217215 | -122.427619516039 | (37.7763801217215, -122.427619516039) | 7 | 9 | 11 | 28852 | 10 | |||
| 30505 | 134448 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 220 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6008017.37449 | 2112409.42175 | 37.7807264060373 | -122.415881023604 | (37.7807264060373, -122.415881023604) | 7 | 10 | 9 | 28852 | 36 | |||
| 30812 | 250283 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 43 United Nations Plz | 24 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 0ft | 6008334.1263 | 2112136.76571 | 37.7799955602742 | -122.414765920936 | (37.7799955602742, -122.414765920936) | 7 | 10 | 9 | 28852 | 36 | |||
| 31654 | 134518 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Fulton St | 17 | Side Yard : Yard | Tree | Private 2 | 6 | Width 4ft | 6007848.65925 | 2112079.5377 | 37.7798111372171 | -122.416441319218 | (37.7798111372171, -122.416441319218) | 7 | 10 | 9 | 28852 | 36 | |||
| 31863 | 143315 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 988 MARKET ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009708.4594 | 2113060.8916 | 37.7826101141483 | -122.410076725762 | (37.7826101141483, -122.410076725762) | 14 | 2 | 9 | 28852 | 36 | |||
| 32081 | 117240 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 635 GROVE ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004711 | 2111132 | 37.7770324835269 | -122.427228354699 | (37.7770324835269, -122.427228354699) | 7 | 9 | 11 | 28852 | 10 | ||||
| 32547 | 25723 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 743 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6004236.2651309 | 2111133.7671277 | 37.7770104768712 | -122.428870736239 | (37.7770104768712, -122.428870736239) | 7 | 9 | 11 | 28852 | 10 | |||
| 32757 | 117239 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 635 GROVE ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2016 12:00:00 AM | 3 | 3x3 | 6004711 | 2111132 | 37.7770324835269 | -122.427228354699 | (37.7770324835269, -122.427228354699) | 7 | 9 | 11 | 28852 | 10 | ||
| 32801 | 248292 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1640 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006331.06836 | 2109825.98151 | 37.7735379567571 | -122.421531248191 | (37.7735379567571, -122.421531248191) | 7 | 2 | 11 | 28852 | 10 |
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) );