trees
47 rows where DBH = 8 and qSpecies_id = 123
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6410 | 91640 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1427 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007757.588641 | 2101343.923892 | 37.7503285203588 | -122.415995902486 | (37.7503285203588, -122.415995902486) | 2 | 4 | 7 | 28859 | 19 | |||
| 14984 | 68126 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1331 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 8 | Permit Number 31876 | 6013566.56944 | 2105672.60835 | 37.7625390358578 | -122.396211251447 | (37.7625390358578, -122.396211251447) | 14 | 3 | 8 | 28856 | 29 | |
| 16406 | 241355 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2970 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6009659.81185 | 2101050.9246 | 37.7496307742409 | -122.409397182327 | (37.7496307742409, -122.409397182327) | 2 | 4 | 7 | 28859 | 19 | |||
| 17382 | 35346 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1124 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 8 | Permit Number 38809 | 6012181.54645 | 2103168.5427 | 37.7555862611206 | -122.400825637793 | (37.7555862611206, -122.400825637793) | 10 | 3 | 8 | 28856 | 29 | |
| 20202 | 136176 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2134 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002833.9768 | 2118210.69092 | 37.7963624418193 | -122.434227733841 | (37.7963624418193, -122.434227733841) | 13 | 9 | 1 | 57 | 17 | |||
| 35434 | 91607 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 882 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007541.210677 | 2104526.186296 | 37.759054118783 | -122.416969598799 | (37.759054118783, -122.416969598799) | 2 | 4 | 7 | 28859 | 19 | ||
| 37335 | 241348 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6009609.90256 | 2105923.09061 | 37.7630058505491 | -122.409913662092 | (37.7630058505491, -122.409913662092) | 8 | 4 | 8 | 28859 | 19 | |||
| 39867 | 91624 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1424 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007717.03025 | 2101352.89464 | 37.7503508716121 | -122.416136791792 | (37.7503508716121, -122.416136791792) | 2 | 4 | 7 | 28859 | 19 | |||
| 43080 | 241352 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6009685.74216 | 2105928.63246 | 37.7630253172965 | -122.409651748936 | (37.7630253172965, -122.409651748936) | 8 | 4 | 8 | 28859 | 19 | |||
| 44084 | 41912 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 642 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 8 | Permit Number 42274 | 5992258.1025 | 2111064.36491 | 37.7761346671426 | -122.470301476833 | (37.7761346671426, -122.470301476833) | 11 | 6 | 2 | 54 | 11 | |
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 87429 | 41913 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 642 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 8 | Permit Number 42274 | 5992259.32657 | 2111046.49076 | 37.7760856603427 | -122.470295940533 | (37.7760856603427, -122.470295940533) | 11 | 6 | 2 | 54 | 11 | |
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 98123 | 241389 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 47 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002625.89983 | 2096003.53123 | 37.7353751906151 | -122.43336004273 | (37.7353751906151, -122.43336004273) | 2 | 7 | 5 | 63 | 7 | |||
| 108205 | 91655 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1155 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007669.369399 | 2102936.135663 | 37.7546954122234 | -122.416413737633 | (37.7546954122234, -122.416413737633) | 2 | 4 | 7 | 28859 | 19 | |||
| 112009 | 196975 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 209 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014043.29115 | 2106063.32562 | 37.7636383743244 | -122.394589793611 | (37.7636383743244, -122.394589793611) | 14 | 3 | 8 | 28856 | 29 | |||
| 112988 | 241350 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6009654.92584 | 2105925.07195 | 37.7630138140553 | -122.409758081181 | (37.7630138140553, -122.409758081181) | 8 | 4 | 8 | 28859 | 19 | |||
| 115294 | 246445 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 457 Duncan St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6003558.45361 | 2099788.20108 | 37.7458198862793 | -122.430405804901 | (37.7458198862793, -122.430405804901) | 2 | 7 | 5 | 63 | 22 | |||
| 124135 | 196995 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 8 | : | Tree | Private 2 | 8 | Width 4ft | 6013853.97089 | 2100136.72086 | 37.7473546683845 | -122.394829506973 | (37.7473546683845, -122.394829506973) | 10 | 3 | 8 | 58 | 1 | |||
| 126071 | 241306 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 635 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007512.51553 | 2105948.57414 | 37.7629580524843 | -122.417169630685 | (37.7629580524843, -122.417169630685) | 8 | 4 | 7 | 28859 | 19 | |||
| 129554 | 120951 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 741 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6007568 | 2105341 | 37.7612929159977 | -122.416934678899 | (37.7612929159977, -122.416934678899) | 2 | 4 | 7 | 28859 | 19 | |||
| 139468 | 91692 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 263 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007399.273892 | 2108147.255986 | 37.7689887468538 | -122.417717146452 | (37.7689887468538, -122.417717146452) | 8 | 4 | 7 | 28853 | 19 | |||
| 144829 | 241322 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 442 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007381.66806 | 2107115.42092 | 37.7661545793962 | -122.417704898167 | (37.7661545793962, -122.417704898167) | 8 | 4 | 7 | 28853 | 19 | |||
| 146245 | 196984 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6011820.47885 | 2100780.87152 | 37.7490100909441 | -122.401906494295 | (37.7490100909441, -122.401906494295) | 10 | 3 | 8 | 58 | 1 | |||
| 146824 | 32353 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2180 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 8 | Permit Number 36907 | 6009556.94604 | 2104659.06953 | 37.759532167893 | -122.410007582777 | (37.759532167893, -122.410007582777) | 2 | 4 | 7 | 28859 | 19 | |
| 153876 | 241326 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 395 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | Width 3ft | 6007429.44982 | 2107410.61084 | 37.7669677904545 | -122.417560553376 | (37.7669677904545, -122.417560553376) | 8 | 4 | 7 | 28853 | 19 | ||
| 155550 | 91589 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 442 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007397.135958 | 2107116.333394 | 37.7661579552478 | -122.417651462281 | (37.7661579552478, -122.417651462281) | 8 | 4 | 7 | 28853 | 19 | |||
| 160670 | 241349 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6009630.95541 | 2105923.95007 | 37.7630093903014 | -122.409840907855 | (37.7630093903014, -122.409840907855) | 8 | 4 | 8 | 28859 | 19 | |||
| 163045 | 91611 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1086 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007607.027989 | 2103338.253155 | 37.7557960290434 | -122.416657816418 | (37.7557960290434, -122.416657816418) | 2 | 4 | 7 | 28859 | 19 | |||
| 170158 | 196985 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6011820.47885 | 2100780.87152 | 37.7490100909441 | -122.401906494295 | (37.7490100909441, -122.401906494295) | 10 | 3 | 8 | 58 | 1 | |||
| 174631 | 91637 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1459 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007767.503009 | 2101164.985993 | 37.749837754658 | -122.415948947877 | (37.749837754658, -122.415948947877) | 2 | 4 | 7 | 28859 | 19 | |||
| 177005 | 91676 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 629 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007499.688693 | 2105999.37525 | 37.7630968189144 | -122.417217594449 | (37.7630968189144, -122.417217594449) | 8 | 4 | 7 | 28859 | 19 | |||
| 177703 | 91647 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1271 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007705.648787 | 2102264.402582 | 37.7528530260896 | -122.416240700263 | (37.7528530260896, -122.416240700263) | 2 | 4 | 7 | 28859 | 19 | ||
| 178993 | 179276 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 716 Peru Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6005258.78381 | 2092467.95462 | 37.7258162992748 | -122.424005829932 | (37.7258162992748, -122.424005829932) | 9 | 7 | 6 | 309 | 5 | |||
| 184445 | 196996 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 10 | : | Tree | Private 2 | 8 | Width 4ft | 6013793.66265 | 2100133.46781 | 37.7473423827584 | -122.395037822335 | (37.7473423827584, -122.395037822335) | 10 | 3 | 8 | 58 | 1 | |||
| 186656 | 241344 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2180 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009557.96176 | 2104644.45965 | 37.7594921093986 | -122.410003038507 | (37.7594921093986, -122.410003038507) | 2 | 4 | 7 | 28859 | 19 | |||
| 190029 | 241343 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2170 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009555.07772 | 2104672.73912 | 37.7595695967776 | -122.410015009398 | (37.7595695967776, -122.410015009398) | 2 | 4 | 7 | 28859 | 19 | |||
| 193578 | 241299 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 793 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007561.10393 | 2105083.16851 | 37.7605845824436 | -122.416940261287 | (37.7605845824436, -122.416940261287) | 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) );