trees
861 rows where qSpecies_id = 18 sorted by Police Districts
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts ▼ | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1422 | 259801 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1180x Brussels St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
3379 | 258367 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 901 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | ||||||||||||||
7878 | 259091 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1298 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
11502 | 259802 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1180x Brussels St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
13366 | 259090 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1298 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
14717 | 259092 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1298 Visitacion Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
18615 | 259800 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1180x Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
697 | 19206 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 630 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012230.08543 | 2117977.14861 | 37.7962500076802 | -122.401698594427 | (37.7962500076802, -122.401698594427) | 3 | 1 | 10 | 28860 | 4 | |||
2588 | 101345 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 600 Chestnut St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | 22 | Permit Number 32655 | 6008773.8267 | 2120774.1665 | 37.8037364477628 | -122.413855954453 | (37.8037364477628, -122.413855954453) | 3 | 1 | 10 | 308 | 23 | ||
4788 | 71255 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1392 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6007494.44606 | 2117816.87319 | 37.7955445300156 | -122.418073553678 | (37.7955445300156, -122.418073553678) | 5 | 1 | 10 | 28858 | 32 | |||
19602 | 129440 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 754 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008519.41832 | 2114901.84945 | 37.7875982238142 | -122.414320608106 | (37.7875982238142, -122.414320608106) | 5 | 1 | 10 | 28858 | 21 | |||
26105 | 111098 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 754 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2015 12:00:00 AM | 3 | 3x3 | 6008536.0762 | 2114905.536 | 37.7876092819021 | -122.414263235869 | (37.7876092819021, -122.414263235869) | 5 | 1 | 10 | 28858 | 21 | ||
36673 | 129452 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007720.96455 | 2120575.51523 | 37.8031318169312 | -122.417485363758 | (37.8031318169312, -122.417485363758) | 5 | 1 | 1 | 308 | 32 | |||
42036 | 1713 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5x6 | 6012507.60717 | 2118114.90232 | 37.796643729085 | -122.40074798855 | (37.796643729085, -122.40074798855) | 3 | 1 | 10 | 28860 | 4 | |||
42195 | 1714 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5x9 | 6012511.35044 | 2118080.94057 | 37.7965506870182 | -122.400732648813 | (37.7965506870182, -122.400732648813) | 3 | 1 | 10 | 28860 | 4 | |||
46340 | 129439 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010043.54378 | 2115756.33064 | 37.7900299214 | -122.409107728349 | (37.7900299214, -122.409107728349) | 5 | 1 | 10 | 28857 | 21 | |||
48303 | 115988 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 499 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777967 | 6011781.45666 | 2118040.71778 | 37.7963995082912 | -122.403255425209 | (37.7963995082912, -122.403255425209) | 3 | 1 | 10 | 28860 | 4 | |
56414 | 129456 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6007719.74229 | 2120576.43903 | 37.803134284681 | -122.417489658942 | (37.803134284681, -122.417489658942) | 5 | 1 | 1 | 308 | 32 | |||
62145 | 32357 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 716 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | 3 | Permit Number 36911 | 6011755.33078 | 2117880.08122 | 37.7959569797808 | -122.40333452059 | (37.7959569797808, -122.40333452059) | 3 | 1 | 10 | 28860 | 4 | ||
63090 | 31965 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 35367 | 6008195.50256 | 2118963.54127 | 37.7987324288073 | -122.415729001311 | (37.7987324288073, -122.415729001311) | 5 | 1 | 10 | 308 | 32 | |||
68049 | 129448 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1190 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008230.44958 | 2115909.44994 | 37.7903486123517 | -122.415391745646 | (37.7903486123517, -122.415391745646) | 5 | 1 | 10 | 28858 | 21 | |||
80866 | 129453 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6007720.64474 | 2120576.42054 | 37.8031342846895 | -122.417486534671 | (37.8031342846895, -122.417486534671) | 5 | 1 | 1 | 308 | 32 | |||
83760 | 129459 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 458 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011895.81451 | 2118092.21584 | 37.7965472956624 | -122.402863344166 | (37.7965472956624, -122.402863344166) | 3 | 1 | 10 | 28860 | 4 | |||
87905 | 101350 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 600 Chestnut St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
93478 | 129444 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1338 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008418.05988 | 2116953.62618 | 37.7932262072758 | -122.414816555443 | (37.7932262072758, -122.414816555443) | 5 | 1 | 10 | 28858 | 21 | |||
94349 | 94202 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53605 | 6008232 | 2118962 | 37.7987302484859 | -122.415602598872 | (37.7987302484859, -122.415602598872) | 5 | 1 | 10 | 308 | 32 | |
102200 | 129447 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1190 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008246.65377 | 2115911.69756 | 37.7903556945065 | -122.415335839278 | (37.7903556945065, -122.415335839278) | 5 | 1 | 10 | 28858 | 21 | |||
106589 | 65445 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 922 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1989 12:00:00 AM | Permit Number 28319 | 6007730.56095344 | 2114797.09154755 | 37.7872662397984 | -122.417042480837 | (37.7872662397984, -122.417042480837) | 13 | 1 | 10 | 28858 | 21 | ||
111235 | 107371 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 448 BROADWAY | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011394.4 | 2118786.8 | 37.798426445485 | -122.404647279275 | (37.798426445485, -122.404647279275) | 3 | 1 | 10 | 308 | 23 | ||||
112886 | 101353 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 600 Chestnut St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
114966 | 98192 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1020 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6008091.62981 | 2118948.72517 | 37.7986859077751 | -122.416087385628 | (37.7986859077751, -122.416087385628) | 5 | 1 | 10 | 308 | 32 | |||
115276 | 122590 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 MacOndray Ln | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6008161 | 2119143 | 37.7992232381339 | -122.415861106147 | (37.7992232381339, -122.415861106147) | 5 | 1 | 10 | 308 | 32 | |||||
124686 | 129449 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 884 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008727.37725 | 2119383.41122 | 37.7999151722102 | -122.413918255029 | (37.7999151722102, -122.413918255029) | 3 | 1 | 10 | 308 | 32 | |||
130306 | 129460 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 468 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011856.71365 | 2118087.11906 | 37.7965311177706 | -122.402998283841 | (37.7965311177706, -122.402998283841) | 3 | 1 | 10 | 28860 | 4 | |||
131351 | 61519 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1161 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1984 12:00:00 AM | 7 | Permit Number 21475 | 6007368.68612 | 2119491.86468 | 37.8001365583177 | -122.418627544125 | (37.8001365583177, -122.418627544125) | 5 | 1 | 1 | 28858 | 32 | ||
134590 | 94203 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53605 | 6008148.35783 | 2118956.03523 | 37.7987091687558 | -122.415891605907 | (37.7987091687558, -122.415891605907) | 5 | 1 | 10 | 308 | 32 | |
135688 | 1716 | Landmark tree 11 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x15 | 6012528.51285 | 2117974.41064 | 37.7962591384932 | -122.400665775228 | (37.7962591384932, -122.400665775228) | 3 | 1 | 10 | 28860 | 4 | |||
136872 | 129455 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007721.09596 | 2120576.41129 | 37.8031342846798 | -122.417484972552 | (37.8031342846798, -122.417484972552) | 5 | 1 | 1 | 308 | 32 | |||
138410 | 101359 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201X Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | 5x5 | Permit Number 32655 | 6008936.1 | 2120783.7 | 37.803771736238 | -122.413295071436 | (37.803771736238, -122.413295071436) | 3 | 1 | 10 | 308 | 23 | ||
142096 | 57397 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1190 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/1976 12:00:00 AM | 11 | Permit Number 16237 | 6008290.06558 | 2115917.44184 | 37.7903739066804 | -122.415186043726 | (37.7903739066804, -122.415186043726) | 5 | 1 | 10 | 28858 | 21 | ||
143341 | 129445 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 24 Priest St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008315.59279 | 2117230.60537 | 37.793980966003 | -122.415190714801 | (37.793980966003, -122.415190714801) | 5 | 1 | 10 | 28858 | 21 | |||
144399 | 129436 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010030.57511 | 2115756.25526 | 37.7900289879055 | -122.409152593735 | (37.7900289879055, -122.409152593735) | 5 | 1 | 10 | 28857 | 21 | |||
147267 | 129461 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 468 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011829.88032 | 2118083.51366 | 37.7965197197689 | -122.403090879839 | (37.7965197197689, -122.403090879839) | 3 | 1 | 10 | 28860 | 4 | |||
147547 | 129462 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 584 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011873.80865 | 2117764.68671 | 37.7956467505394 | -122.402916441935 | (37.7956467505394, -122.402916441935) | 3 | 1 | 10 | 28860 | 4 | |||
152651 | 27626 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2310X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6008495.09386 | 2120769.31703 | 37.8037074748624 | -122.414820184334 | (37.8037074748624, -122.414820184334) | 5 | 1 | 10 | 308 | 23 | |||
153900 | 142587 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2320 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6008491.26 | 2120799.1265 | 37.8037891087643 | -122.414835562646 | (37.8037891087643, -122.414835562646) | 5 | 1 | 10 | 308 | 23 | |||
155983 | 129437 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010035.0094 | 2115756.16478 | 37.7900289878849 | -122.409137245009 | (37.7900289878849, -122.409137245009) | 5 | 1 | 10 | 28857 | 21 | |||
156724 | 129454 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007720.06236 | 2120575.53372 | 37.8031318169374 | -122.41748848713 | (37.8031318169374, -122.41748848713) | 5 | 1 | 1 | 308 | 32 | |||
158830 | 1715 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5x6 | 6012518.40757 | 2118034.67495 | 37.796424046288 | -122.400704977573 | (37.796424046288, -122.400704977573) | 3 | 1 | 10 | 28860 | 4 | |||
159355 | 129458 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 731 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6012131.08094 | 2118327.87745 | 37.7972074996935 | -122.402065841564 | (37.7972074996935, -122.402065841564) | 3 | 1 | 10 | 308 | 4 | |||
164313 | 142575 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201 MASON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6008927.1192 | 2120859.172 | 37.8039784592472 | -122.413331490554 | (37.8039784592472, -122.413331490554) | 3 | 1 | 10 | 308 | 23 | |||
166939 | 35235 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1077 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 6 | Permit Number 38732 | 6007771.26508 | 2119552.1201 | 37.8003246614186 | -122.417238733675 | (37.8003246614186, -122.417238733675) | 5 | 1 | 1 | 308 | 32 | |
166949 | 1718 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 9x6 | 6012538.25649 | 2117884.3369 | 37.7960123609319 | -122.400625729299 | (37.7960123609319, -122.400625729299) | 3 | 1 | 10 | 28860 | 4 | |||
166998 | 33958 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 690 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1997 12:00:00 AM | 15 | Permit Number 37913 | 6008590.6293 | 2120749.6774 | 37.8036589168384 | -122.414488187223 | (37.8036589168384, -122.414488187223) | 3 | 1 | 10 | 308 | 23 | ||
168624 | 115987 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 499 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011766.1004 | 2118039.48156 | 37.7963952562896 | -122.40330847443 | (37.7963952562896, -122.40330847443) | 3 | 1 | 10 | 28860 | 4 | |||
172622 | 129446 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1329 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008344.2402 | 2117236.00141 | 37.7939973921104 | -122.415091973713 | (37.7939973921104, -122.415091973713) | 5 | 1 | 10 | 28858 | 21 | |||
174473 | 254175 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1089 Chestnut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2018 12:00:00 AM | 3 | 3x3 | 6006628.18877 | 2120429.73547 | 37.8026699959528 | -122.421256591898 | (37.8026699959528, -122.421256591898) | 5 | 1 | 1 | 28858 | 32 | ||
183685 | 142580 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 650 CHESTNUT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6008660.8 | 2120758.6253 | 37.8036874273397 | -122.414245990591 | (37.8036874273397, -122.414245990591) | 3 | 1 | 10 | 308 | 23 | |||
190708 | 129438 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010041.47641 | 2115755.35321 | 37.7900271217973 | -122.409114812309 | (37.7900271217973, -122.409114812309) | 5 | 1 | 10 | 28857 | 21 | |||
192764 | 106106 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 708 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6011765.54028 | 2117816.6633 | 37.7957834196109 | -122.403294730072 | (37.7957834196109, -122.403294730072) | 3 | 1 | 10 | 28860 | 4 | ||||
50640 | 129442 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Cyril Magnin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010104.97756 | 2114284.67603 | 37.7859925517698 | -122.408791302782 | (37.7859925517698, -122.408791302782) | 14 | 10 | 10 | 28852 | 36 | |||
57443 | 129441 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Cyril Magnin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010109.81427 | 2114257.21673 | 37.7859174259901 | -122.408772631062 | (37.7859174259901, -122.408772631062) | 14 | 10 | 10 | 28852 | 36 | |||
159582 | 129443 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Cyril Magnin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010100.50138 | 2114305.77616 | 37.7860502369758 | -122.408808278389 | (37.7860502369758, -122.408808278389) | 14 | 10 | 10 | 28852 | 36 | |||
11467 | 82943 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52427 | 6009392.50715 | 2110510.58601 | 37.7755898643032 | -122.410989600209 | (37.7755898643032, -122.410989600209) | 8 | 2 | 9 | 28853 | 34 | |
20284 | 227665 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 46 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006330.78292 | 2109566.87483 | 37.7728264958779 | -122.421513830121 | (37.7728264958779, -122.421513830121) | 8 | 2 | 9 | 28853 | 19 | |||
31086 | 191288 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 720 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014381.59657 | 2110521.77598 | 37.7758990935001 | -122.39373177471 | (37.7758990935001, -122.39373177471) | 6 | 2 | 9 | 310 | 20 | |||
33337 | 108294 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | |||
36272 | 108295 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | ||||
36949 | 227666 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 46 Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006306.62249 | 2109592.20963 | 37.7728946968577 | -122.421599203664 | (37.7728946968577, -122.421599203664) | 8 | 2 | 9 | 28853 | 19 | |||
39091 | 191280 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014475.48285 | 2110565.83203 | 37.7760252782883 | -122.393410079138 | (37.7760252782883, -122.393410079138) | 6 | 2 | 9 | 28856 | 20 | |||
41389 | 191296 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 940 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6014597.30582 | 2110326.98215 | 37.7753762177666 | -122.392971942918 | (37.7753762177666, -122.392971942918) | 6 | 2 | 9 | 310 | 20 | |||
41810 | 191276 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014137.59227 | 2110902.38763 | 37.7769306051104 | -122.394602513603 | (37.7769306051104, -122.394602513603) | 6 | 2 | 9 | 28856 | 20 | |||
45106 | 246316 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006848.8767 | 2108962.1326 | 37.7711952166815 | -122.41967876451 | (37.7711952166815, -122.41967876451) | 8 | 2 | 9 | 28853 | 19 | |||
50235 | 191277 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014120.49796 | 2110919.75939 | 37.7769773536703 | -122.394662865301 | (37.7769773536703, -122.394662865301) | 6 | 2 | 9 | 28856 | 20 | |||
51728 | 191273 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014193.41583 | 2110841.84159 | 37.7767674626879 | -122.394405160994 | (37.7767674626879, -122.394405160994) | 6 | 2 | 9 | 28856 | 20 | |||
52515 | 191285 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 720 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014337.49405 | 2110565.62241 | 37.776017035092 | -122.3938874078 | (37.776017035092, -122.3938874078) | 6 | 2 | 9 | 310 | 20 | |||
57744 | 191291 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 940 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014507.50601 | 2110409.04953 | 37.7755965678638 | -122.393288327987 | (37.7755965678638, -122.393288327987) | 6 | 2 | 9 | 310 | 20 | |||
63082 | 191270 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014244.47605 | 2110787.29844 | 37.7766205377503 | -122.394224707529 | (37.7766205377503, -122.394224707529) | 6 | 2 | 9 | 28856 | 20 | |||
66891 | 191286 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 720 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014348.90708 | 2110556.61592 | 37.7759929395558 | -122.393847296238 | (37.7759929395558, -122.393847296238) | 6 | 2 | 9 | 310 | 20 | |||
72423 | 191283 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6014423.24539 | 2110620.23478 | 37.7761717535676 | -122.39359459214 | (37.7761717535676, -122.39359459214) | 6 | 2 | 9 | 28856 | 20 | |||
73992 | 191281 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014459.12873 | 2110582.79031 | 37.776070933269 | -122.393467839873 | (37.776070933269, -122.393467839873) | 6 | 2 | 9 | 28856 | 20 | |||
75837 | 191287 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 720 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014360.2734 | 2110545.30097 | 37.7759625028975 | -122.393807184665 | (37.7759625028975, -122.393807184665) | 6 | 2 | 9 | 310 | 20 | |||
76863 | 191292 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 940 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014526.81372 | 2110393.83261 | 37.7755558582611 | -122.393220472347 | (37.7755558582611, -122.393220472347) | 6 | 2 | 9 | 310 | 20 | |||
81001 | 246317 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006842.0158 | 2108939.8347 | 37.7711336054687 | -122.419700914309 | (37.7711336054687, -122.419700914309) | 8 | 2 | 9 | 28853 | 19 | |||
81296 | 191274 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014170.53603 | 2110866.45323 | 37.7768337688053 | -122.394486033405 | (37.7768337688053, -122.394486033405) | 6 | 2 | 9 | 28856 | 20 | |||
81548 | 227664 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 46 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006352.61358 | 2109543.15644 | 37.7727626017523 | -122.421436630498 | (37.7727626017523, -122.421436630498) | 8 | 2 | 9 | 28853 | 19 | |||
88043 | 191269 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 538 Delancey St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6015147.69888 | 2113724.07494 | 37.7847344271845 | -122.391305511737 | (37.7847344271845, -122.391305511737) | 6 | 2 | 9 | 28856 | 6 | ||||
88948 | 191275 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014152.76855 | 2110885.05471 | 37.7768838565355 | -122.394548799799 | (37.7768838565355, -122.394548799799) | 6 | 2 | 9 | 28856 | 20 | |||
111463 | 191289 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 720 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014403.28238 | 2110504.70975 | 37.7758534385095 | -122.393655562567 | (37.7758534385095, -122.393655562567) | 6 | 2 | 9 | 310 | 20 | |||
112779 | 191282 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014441.41184 | 2110601.16162 | 37.7761203923639 | -122.393530413818 | (37.7761203923639, -122.393530413818) | 6 | 2 | 9 | 28856 | 20 | |||
115877 | 191267 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 538 Delancey St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6015157.46118 | 2113744.49366 | 37.7847910341296 | -122.391273164948 | (37.7847910341296, -122.391273164948) | 6 | 2 | 9 | 28856 | 6 | ||||
116395 | 82944 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52427 | 6009357.52887 | 2110544.08161 | 37.7756798738576 | -122.4111129656 | (37.7756798738576, -122.4111129656) | 8 | 2 | 9 | 28853 | 34 | |
119184 | 191279 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6014488.65143 | 2110553.2747 | 37.7759915303161 | -122.393363646226 | (37.7759915303161, -122.393363646226) | 6 | 2 | 9 | 28856 | 20 | |||
128268 | 191295 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 940 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6014582.55786 | 2110345.63689 | 37.7754266202868 | -122.393024265473 | (37.7754266202868, -122.393024265473) | 6 | 2 | 9 | 310 | 20 | |||
135015 | 191293 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 940 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014546.37169 | 2110379.31646 | 37.775517086679 | -122.393151800112 | (37.775517086679, -122.393151800112) | 6 | 2 | 9 | 310 | 20 | |||
136464 | 191294 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 940 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6014564.69623 | 2110362.23682 | 37.7754712077696 | -122.393087215303 | (37.7754712077696, -122.393087215303) | 6 | 2 | 9 | 310 | 20 | |||
144752 | 246315 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006857.4528 | 2108984.4305 | 37.7712569245067 | -122.419650681714 | (37.7712569245067, -122.419650681714) | 8 | 2 | 9 | 28853 | 19 | |||
144967 | 191271 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014227.23158 | 2110805.88928 | 37.7766706254784 | -122.394285663563 | (37.7766706254784, -122.394285663563) | 6 | 2 | 9 | 28856 | 20 | |||
151514 | 191290 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 720 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014418.02792 | 2110488.47672 | 37.7758096856109 | -122.393603417186 | (37.7758096856109, -122.393603417186) | 6 | 2 | 9 | 310 | 20 | |||
152679 | 191278 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014098.28059 | 2110942.62046 | 37.7770388897689 | -122.394741323978 | (37.7770388897689, -122.394741323978) | 6 | 2 | 9 | 28856 | 20 |
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) );