trees
575 rows where qSpecies_id = 123 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53750 | 91599 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 700 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007449 | 2105508 | 37.7617447647779 | -122.41735808585 | (37.7617447647779, -122.41735808585) | 2 | 4 | 7 | 28859 | 19 | ||
53988 | 91694 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 245 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007404.295323 | 2108246.270012 | 37.7692608986091 | -122.417706796624 | (37.7692608986091, -122.417706796624) | 8 | 4 | 7 | 28853 | 19 | ||
54319 | 241288 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1201 Vermont St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6011465.27105 | 2102063.55943 | 37.7525122416483 | -122.403225029932 | (37.7525122416483, -122.403225029932) | 10 | 4 | 8 | 28859 | 19 | |||
54649 | 241274 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2616 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010311.63301 | 2104008.02665 | 37.7577868194278 | -122.407351591615 | (37.7577868194278, -122.407351591615) | 10 | 4 | 7 | 28859 | 19 | |||
55070 | 90888 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1643 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5990427.38922 | 2110587.78256 | 37.7747200883254 | -122.47659951411 | (37.7747200883254, -122.47659951411) | 11 | 6 | 2 | 55 | 26 | ||
55110 | 196970 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015850.66313 | 2105843.80284 | 37.7631359267068 | -122.388323281596 | (37.7631359267068, -122.388323281596) | 14 | 3 | 8 | 28856 | 29 | |||
55570 | 100314 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1683 Galvez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015409.74359 | 2097962.08476 | 37.7414699491892 | -122.389297877816 | (37.7414699491892, -122.389297877816) | 10 | 3 | 8 | 58 | 1 | |||
55713 | 136180 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3134 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999407.16472 | 2119635.33058 | 37.8000790286731 | -122.446187711617 | (37.8000790286731, -122.446187711617) | 13 | 9 | 1 | 57 | 17 | |||
56230 | 136182 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3140 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999403.04173 | 2119664.02877 | 37.8001575907471 | -122.446204044176 | (37.8001575907471, -122.446204044176) | 13 | 9 | 1 | 57 | 17 | |||
56282 | 87763 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1303 Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6001194 | 2110018 | 37.7737741980345 | -122.439314854348 | (37.7737741980345, -122.439314854348) | 15 | 5 | 11 | 29492 | 10 | |||
56651 | 91619 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1286 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 10 | 3x3 | 6007670.444381 | 2102173.036115 | 37.7526001749043 | -122.416355973027 | (37.7526001749043, -122.416355973027) | 2 | 4 | 7 | 28859 | 19 | |||
56814 | 241333 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 259 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007398.77752 | 2108173.34419 | 37.7690603509832 | -122.417720712761 | (37.7690603509832, -122.417720712761) | 8 | 4 | 7 | 28853 | 19 | |||
57032 | 91601 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 746 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007497.69689 | 2105311.935767 | 37.7612091575166 | -122.417175768763 | (37.7612091575166, -122.417175768763) | 2 | 4 | 7 | 28859 | 19 | |||
57267 | 241390 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 381 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004068.12547 | 2098354.29911 | 37.7419115792635 | -122.428541241382 | (37.7419115792635, -122.428541241382) | 2 | 7 | 5 | 63 | 7 | |||
58715 | 196964 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015932.05228 | 2105848.00164 | 37.7631519652185 | -122.3880420744 | (37.7631519652185, -122.3880420744) | 14 | 3 | 8 | 28856 | 29 | |||
58844 | 29771 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 501X Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008832.60809 | 2121061.07086 | 37.8045275162019 | -122.413672842682 | (37.8045275162019, -122.413672842682) | 3 | 1 | 10 | 308 | 23 | |||
58857 | 197005 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6015945.83282 | 2113971.21012 | 37.7854572671771 | -122.388561464349 | (37.7854572671771, -122.388561464349) | 6 | 2 | 9 | 28856 | 6 | |||
59371 | 91679 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 565 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007478.430249 | 2106383.249501 | 37.7641496522652 | -122.417318325278 | (37.7641496522652, -122.417318325278) | 8 | 4 | 7 | 28859 | 19 | ||
59684 | 91684 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 387 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007418.830408 | 2107437.729103 | 37.7670416532981 | -122.41759920657 | (37.7670416532981, -122.41759920657) | 8 | 4 | 7 | 28853 | 19 | ||
59988 | 91630 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1490x South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007737.478632 | 2100983.83524 | 37.7493386674544 | -122.41603994665 | (37.7493386674544, -122.41603994665) | 2 | 4 | 7 | 28859 | 19 | |||
60226 | 100425 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
60318 | 91631 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1500 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007741.508083 | 2100911.11035 | 37.7491392078361 | -122.416020863166 | (37.7491392078361, -122.416020863166) | 2 | 4 | 7 | 28859 | 19 | |||
60684 | 241329 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 349 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007417.32507 | 2107664.81767 | 37.7676651004942 | -122.417620510295 | (37.7676651004942, -122.417620510295) | 8 | 4 | 7 | 28853 | 19 | |||
60767 | 91618 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1240 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007656.818859 | 2102429.616316 | 37.7533039196294 | -122.41642126514 | (37.7533039196294, -122.41642126514) | 2 | 4 | 7 | 28859 | 19 | |||
61090 | 104044 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601X Kansas St | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 70 | 9x9 | 6011818.89895 | 2100809.64818 | 37.7490890172439 | -122.401913980245 | (37.7490890172439, -122.401913980245) | 10 | 3 | 8 | 58 | 1 | |||
61838 | 90896 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1145 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992053.33041 | 2110644.47867 | 37.7749699321879 | -122.47097923688 | (37.7749699321879, -122.47097923688) | 11 | 6 | 2 | 54 | 11 | ||
62289 | 91591 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 490 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007414.001232 | 2106821.277656 | 37.7653487502341 | -122.41757221445 | (37.7653487502341, -122.41757221445) | 8 | 4 | 7 | 28853 | 19 | ||
62748 | 196988 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6011818.89895 | 2100809.64818 | 37.7490890172439 | -122.401913980245 | (37.7490890172439, -122.401913980245) | 10 | 3 | 8 | 58 | 1 | |||
64123 | 123208 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993131.19371 | 2112699.04699 | 37.7806735020779 | -122.467400140372 | (37.7806735020779, -122.467400140372) | 11 | 6 | 2 | 54 | 11 | |||
64144 | 95296 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4517 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015219.41618 | 2096207.76459 | 37.7366423919508 | -122.389833460403 | (37.7366423919508, -122.389833460403) | 10 | 3 | 8 | 58 | 1 | |||
64306 | 22261 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4655X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6015123.96867 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | 10 | 3 | 8 | 58 | 1 | |||
67006 | 91687 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 373 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007414.352338 | 2107516.072508 | 37.7672565139252 | -122.417620248867 | (37.7672565139252, -122.417620248867) | 8 | 4 | 7 | 28853 | 19 | |||
67071 | 3776 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 6 Carpenter Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016649.2597904 | 2095536.4485417 | 37.7348782815847 | -122.38484307413 | (37.7348782815847, -122.38484307413) | 10 | 3 | 8 | 58 | 1 | ||
67085 | 241273 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 55 Haight St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6005874.88911 | 2109629.37494 | 37.7729723901943 | -122.423095264536 | (37.7729723901943, -122.423095264536) | 7 | 9 | 11 | 28852 | 10 | |||
67177 | 241335 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Coso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007049.61155 | 2099992.5386 | 37.7465780921238 | -122.418348334311 | (37.7465780921238, -122.418348334311) | 2 | 7 | 7 | 28859 | 2 | |||
67242 | 241290 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1227 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011160.10458 | 2102427.21865 | 37.753493722159 | -122.404305946667 | (37.753493722159, -122.404305946667) | 10 | 4 | 8 | 28859 | 19 | |||
67599 | 91656 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1141 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007665.027497 | 2103014.499609 | 37.7549103375799 | -122.416434303552 | (37.7549103375799, -122.416434303552) | 2 | 4 | 7 | 28859 | 19 | |||
67783 | 90864 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2207 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988718.74486 | 2110525.68485 | 37.7744503344144 | -122.482505440318 | (37.7744503344144, -122.482505440318) | 11 | 6 | 2 | 55 | 26 | ||
67982 | 241367 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3747 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005339.63853 | 2104274.22686 | 37.7582382098444 | -122.424565763112 | (37.7582382098444, -122.424565763112) | 2 | 4 | 5 | 28859 | 19 | |||
68023 | 241368 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2879 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009498.83241 | 2102749.66821 | 37.75428612472 | -122.410073769282 | (37.75428612472, -122.410073769282) | 2 | 4 | 7 | 28859 | 19 | |||
68475 | 91629 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1474 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007732.521449 | 2101073.304189 | 37.7495840503135 | -122.416063424016 | (37.7495840503135, -122.416063424016) | 2 | 4 | 7 | 28859 | 19 | ||
69848 | 91667 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 793 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007551.894714 | 2105056.665982 | 37.7605112945984 | -122.416970234051 | (37.7605112945984, -122.416970234051) | 2 | 4 | 7 | 28859 | 19 | ||
70671 | 196993 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 6 | : | Tree | Private 2 | 7 | Width 4ft | 6013912.09606 | 2100139.02388 | 37.7473642236913 | -122.394628673985 | (37.7473642236913, -122.394628673985) | 10 | 3 | 8 | 58 | 1 | |||
71003 | 22267 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4655X 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | 6 | 3X3 | 6015123.96867 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | 10 | 3 | 8 | 58 | 1 | ||
71899 | 136184 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1100 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006503.30451 | 2120455.88239 | 37.8027347473741 | -122.421690613452 | (37.8027347473741, -122.421690613452) | 5 | 9 | 1 | 28858 | 32 | |||
73623 | 247601 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Tompkins Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6009211.63365 | 2096404.06359 | 37.7368463915456 | -122.410618895163 | (37.7368463915456, -122.410618895163) | 10 | 7 | 7 | 28859 | 2 | |||
74482 | 91579 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 170 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2013 01:09:00 PM | 3 | 3x3 | 6007322.882921 | 2108766.782992 | 37.7706855226421 | -122.418025303656 | (37.7706855226421, -122.418025303656) | 8 | 2 | 9 | 28853 | 19 | |||
74677 | 197008 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015819.96471 | 2114109.17282 | 37.7858291053701 | -122.389006570307 | (37.7858291053701, -122.389006570307) | 6 | 2 | 9 | 28856 | 6 | |||
75362 | 91635 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1515 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007819 | 2100813 | 37.7488741754589 | -122.415745948384 | (37.7488741754589, -122.415745948384) | 2 | 4 | 7 | 28859 | 19 | ||
75650 | 241361 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 608 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009795.10344 | 2105420.22693 | 37.7616354789124 | -122.409237625525 | (37.7616354789124, -122.409237625525) | 2 | 4 | 8 | 28859 | 19 | |||
76553 | 123210 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993133.98431 | 2112655.94122 | 37.7805553064396 | -122.467387351051 | (37.7805553064396, -122.467387351051) | 11 | 6 | 2 | 54 | 11 | |||
76848 | 22262 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4655X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6015123.96867 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | 10 | 3 | 8 | 58 | 1 | |||
77309 | 91657 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1133 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007662.546411 | 2103059.279009 | 37.7550331520704 | -122.416446055556 | (37.7550331520704, -122.416446055556) | 2 | 4 | 7 | 28859 | 19 | |||
77851 | 90569 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1818 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989920.28238 | 2110623.46415 | 37.7747886345028 | -122.478356290001 | (37.7747886345028, -122.478356290001) | 11 | 6 | 2 | 55 | 26 | ||
78586 | 241277 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1400 Potrero Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010729.0783 | 2101044.09639 | 37.749671877762 | -122.405699121544 | (37.749671877762, -122.405699121544) | 10 | 4 | 7 | 28859 | 19 | |||
79595 | 90884 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1751 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990130.69935 | 2110573.90659 | 37.7746647760157 | -122.477624799049 | (37.7746647760157, -122.477624799049) | 11 | 6 | 2 | 55 | 26 | ||
79863 | 241303 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 731 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007544.46079 | 2105381.89304 | 37.7614038747014 | -122.417018988842 | (37.7614038747014, -122.417018988842) | 2 | 4 | 7 | 28859 | 19 | |||
80479 | 91680 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 565 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007478.430249 | 2106383.249501 | 37.7641496522652 | -122.417318325278 | (37.7641496522652, -122.417318325278) | 8 | 4 | 7 | 28859 | 19 | ||
80892 | 120913 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 499X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6007431 | 2106864 | 37.7654670122947 | -122.41751644763 | (37.7654670122947, -122.41751644763) | 8 | 4 | 7 | 28853 | 19 | |||
80922 | 104045 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601X Kansas St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 4 | 3x6 | 6011820.27046 | 2100794.29001 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | 10 | 3 | 8 | 58 | 1 | |||
81154 | 91654 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1169 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007673.711302 | 2102857.771696 | 37.7544804867979 | -122.416393171829 | (37.7544804867979, -122.416393171829) | 2 | 4 | 7 | 28859 | 19 | |||
81234 | 241340 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2701 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009746.5481 | 2105459.14432 | 37.7617396168174 | -122.409408306065 | (37.7617396168174, -122.409408306065) | 2 | 4 | 8 | 28859 | 19 | |||
82690 | 241362 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 610 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009794.30933 | 2105409.48411 | 37.7616059370772 | -122.409239613928 | (37.7616059370772, -122.409239613928) | 2 | 4 | 8 | 28859 | 19 | |||
83333 | 196981 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2460 Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009761.09751 | 2107855.1809 | 37.7683194004524 | -122.409527097504 | (37.7683194004524, -122.409527097504) | 8 | 4 | 8 | 28853 | 19 | |||
84099 | 91688 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 349 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007406.675646 | 2107650.375519 | 37.7676248464865 | -122.417656321662 | (37.7676248464865, -122.417656321662) | 8 | 4 | 7 | 28853 | 19 | |||
84687 | 91615 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1176 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007636.253645 | 2102810.779435 | 37.754349350274 | -122.416519382003 | (37.754349350274, -122.416519382003) | 2 | 4 | 7 | 28859 | 19 | |||
84968 | 241376 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3777 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004606.4364 | 2101890.62925 | 37.7516519753774 | -122.426931737306 | (37.7516519753774, -122.426931737306) | 2 | 4 | 5 | 28862 | 22 | |||
85376 | 85063 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4532 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2007 12:00:00 AM | 3 | 3x3 | 6015094.5224 | 2096297.78902 | 37.7368826538298 | -122.390271563398 | (37.7368826538298, -122.390271563398) | 10 | 3 | 8 | 58 | 1 | ||
86391 | 241321 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 356 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007355.98691 | 2107612.7207 | 37.7675186027402 | -122.417828978541 | (37.7675186027402, -122.417828978541) | 8 | 4 | 7 | 28853 | 19 | |||
86392 | 241360 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 600 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009793.68997 | 2105435.76266 | 37.7616780573116 | -122.409243610512 | (37.7616780573116, -122.409243610512) | 2 | 4 | 8 | 28859 | 19 | |||
86529 | 179278 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 223 Pioche St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006228.66725 | 2093396.90262 | 37.7284216981869 | -122.420718924746 | (37.7284216981869, -122.420718924746) | 9 | 7 | 7 | 309 | 5 | |||
86818 | 22265 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4655X 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | 6 | 3X3 | 6015123.96867 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | 10 | 3 | 8 | 58 | 1 | ||
87205 | 91675 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 637 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007502.174043 | 2105954.495988 | 37.7629737307137 | -122.41720581807 | (37.7629737307137, -122.41720581807) | 8 | 4 | 7 | 28859 | 19 | |||
87499 | 197007 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6015822.85417 | 2114091.9182 | 37.7857818882589 | -122.388995368366 | (37.7857818882589, -122.388995368366) | 6 | 2 | 9 | 28856 | 6 | |||
87512 | 91604 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 802 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007516.377022 | 2104974.620116 | 37.7602840176254 | -122.417087260164 | (37.7602840176254, -122.417087260164) | 2 | 4 | 7 | 28859 | 19 | ||
87745 | 241345 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6009569.08803 | 2105916.84613 | 37.7629864171226 | -122.410054385304 | (37.7629864171226, -122.410054385304) | 8 | 4 | 8 | 28859 | 19 | |||
87982 | 91650 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1245 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007697.947405 | 2102409.42617 | 37.7532507948704 | -122.416277603857 | (37.7532507948704, -122.416277603857) | 2 | 4 | 7 | 28859 | 19 | ||
88076 | 196990 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 1 | : | Tree | Private 2 | 6 | Width 4ft | 6014143.12746 | 2100151.41021 | 37.7474110756645 | -122.393830644379 | (37.7474110756645, -122.393830644379) | 10 | 3 | 8 | 58 | 1 | |||
88350 | 91701 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 101x South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007269.02291 | 2109328.047293 | 37.7722235898389 | -122.41825140648 | (37.7722235898389, -122.41825140648) | 8 | 2 | 9 | 28853 | 19 | |||
88525 | 90879 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1917 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989637.04672 | 2110556.02381 | 37.7745870153825 | -122.479331114808 | (37.7745870153825, -122.479331114808) | 11 | 6 | 2 | 55 | 26 | ||
88879 | 241357 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1081 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6008659.53051 | 2102232.08888 | 37.7528178906343 | -122.412939704518 | (37.7528178906343, -122.412939704518) | 2 | 4 | 7 | 28859 | 19 | |||
89482 | 91663 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 859 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007573.699386 | 2104662.928197 | 37.7594314080197 | -122.416866925134 | (37.7594314080197, -122.416866925134) | 2 | 4 | 7 | 28859 | 19 | ||
89642 | 90894 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1527 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990818.86617 | 2110597.98209 | 37.7747707916372 | -122.475246074555 | (37.7747707916372, -122.475246074555) | 11 | 6 | 2 | 54 | 26 | ||
89764 | 241327 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 377 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007424.50403 | 2107516.88319 | 37.7672593111026 | -122.417585193005 | (37.7672593111026, -122.417585193005) | 8 | 4 | 7 | 28853 | 19 | |||
90022 | 91674 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 697 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007520.814164 | 2105617.901611 | 37.7620505693283 | -122.417117496488 | (37.7620505693283, -122.417117496488) | 8 | 4 | 7 | 28859 | 19 | |||
90241 | 241363 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 610 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009795.29828 | 2105395.5079 | 37.7615676169818 | -122.409235207249 | (37.7615676169818, -122.409235207249) | 2 | 4 | 8 | 28859 | 19 | |||
91402 | 241353 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6009702.25291 | 2105928.94008 | 37.7630270871447 | -122.409594665358 | (37.7630270871447, -122.409594665358) | 8 | 4 | 8 | 28859 | 19 | |||
91890 | 22277 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/31/1992 12:00:00 AM | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
91934 | 91678 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 565 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007478.430249 | 2106383.249501 | 37.7641496522652 | -122.417318325278 | (37.7641496522652, -122.417318325278) | 8 | 4 | 7 | 28859 | 19 | ||
92135 | 241378 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 273 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004715.15963 | 2100148.28162 | 37.746874039199 | -122.426431711567 | (37.746874039199, -122.426431711567) | 2 | 7 | 5 | 63 | 22 | |||
92157 | 121263 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 700 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6007449 | 2105508 | 37.7617447647779 | -122.41735808585 | (37.7617447647779, -122.41735808585) | 2 | 4 | 7 | 28859 | 19 | |||
92182 | 196991 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 2 | : | Tree | Private 2 | 5 | Width 4ft | 6014086.84637 | 2100149.18925 | 37.7474018495283 | -122.394025106589 | (37.7474018495283, -122.394025106589) | 10 | 3 | 8 | 58 | 1 | |||
92727 | 241365 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1475 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6010134.56863 | 2100721.5441 | 37.7487529567978 | -122.407732226982 | (37.7487529567978, -122.407732226982) | 2 | 4 | 7 | 28859 | 19 | |||
92775 | 136185 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010045.72464 | 2116634.21167 | 37.7924404929984 | -122.409162155311 | (37.7924404929984, -122.409162155311) | 3 | 1 | 10 | 28857 | 4 | |||
93143 | 22280 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/31/1992 12:00:00 AM | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
93792 | 241347 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6009595.63011 | 2105921.4482 | 37.7630005409651 | -122.409962909868 | (37.7630005409651, -122.409962909868) | 8 | 4 | 8 | 28859 | 19 | |||
94223 | 136177 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2028 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003216.31619 | 2118958.46656 | 37.7984373333682 | -122.432958210354 | (37.7984373333682, -122.432958210354) | 13 | 9 | 1 | 57 | 17 | |||
94686 | 95297 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4517 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015219.41618 | 2096207.76459 | 37.7366423919508 | -122.389833460403 | (37.7366423919508, -122.389833460403) | 10 | 3 | 8 | 58 | 1 | |||
94776 | 91627 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1468 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007730.662506 | 2101106.855019 | 37.7496760688109 | -122.416072228065 | (37.7496760688109, -122.416072228065) | 2 | 4 | 7 | 28859 | 19 | |||
95212 | 91600 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 722 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007467 | 2105381 | 37.7613970649262 | -122.417286830828 | (37.7613970649262, -122.417286830828) | 2 | 4 | 7 | 28859 | 19 |
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) );