trees
963 rows where qCaretaker_id = 2 and qSpecies_id = 53 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
64328 | 44245 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 10 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | Permit Number 43680 | 6010447.16728471 | 2099896.56831072 | 37.7465052482739 | -122.406593130128 | (37.7465052482739, -122.406593130128) | 2 | 7 | 7 | 28859 | 2 | |||
46064 | 106808 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 10 LOYOLA TER | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 772884 | 5998469.3 | 2110801.2 | 37.7757692329232 | -122.448796407891 | (37.7757692329232, -122.448796407891) | 15 | 6 | 2 | 29492 | 16 | |||
58136 | 106999 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 10 Loyola Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998469.2817 | 2110801.2236 | 37.7757692966762 | -122.448796472896 | (37.7757692966762, -122.448796472896) | 15 | 6 | 2 | 29492 | 16 | |||||
96594 | 94566 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998051 | 2107197 | 37.7658490933668 | -122.449983584058 | (37.7658490933668, -122.449983584058) | 15 | 5 | 11 | 29492 | 9 | ||||
128996 | 94567 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998051 | 2107197 | 37.7658490933668 | -122.449983584058 | (37.7658490933668, -122.449983584058) | 15 | 5 | 11 | 29492 | 9 | ||||
79809 | 4593 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6011460.12974 | 2118136.30046 | 37.7966440043551 | -122.404374021953 | (37.7966440043551, -122.404374021953) | 3 | 1 | 10 | 308 | 4 | |||
9205 | 96542 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 767720 | 6013094 | 2116579 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | 4 | 1 | 10 | 28860 | 6 | ||||
118656 | 96541 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 767720 | 6013094 | 2116579 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | 4 | 1 | 10 | 28860 | 6 | ||||
47816 | 107839 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1000x LEAVENWORTH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008256 | 2115925 | 37.790392745036 | -122.415304443955 | (37.790392745036, -122.415304443955) | 5 | 1 | 10 | 28858 | 21 | ||||
143675 | 107836 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1000x LEAVENWORTH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008256 | 2115925 | 37.790392745036 | -122.415304443955 | (37.790392745036, -122.415304443955) | 5 | 1 | 10 | 28858 | 21 | |||
3159 | 94569 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100@ Cole Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998051 | 2107197 | 37.7658490933668 | -122.449983584058 | (37.7658490933668, -122.449983584058) | 15 | 5 | 11 | 29492 | 9 | ||||
145382 | 56574 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100x Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6010338.9406 | 2121168.3232 | 37.8049064763082 | -122.408467587357 | (37.8049064763082, -122.408467587357) | 3 | 1 | 10 | 308 | 23 | ||||
136831 | 7225 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1015 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x5 | 6003380.095 | 2111793.84702 | 37.7787743954893 | -122.431879635495 | (37.7787743954893, -122.431879635495) | 15 | 9 | 11 | 29490 | 41 | |||
28305 | 121625 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 101x Trenton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010049 | 2117862 | 37.7958118850813 | -122.409237502382 | (37.7958118850813, -122.409237502382) | 3 | 1 | 10 | 308 | 4 | ||||
154699 | 121624 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 101x Trenton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010049 | 2117862 | 37.7958118850813 | -122.409237502382 | (37.7958118850813, -122.409237502382) | 3 | 1 | 10 | 308 | 4 | ||||
159266 | 7227 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1025 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6003385.45092 | 2111827.8386 | 37.7788680315263 | -122.431863535021 | (37.7788680315263, -122.431863535021) | 15 | 9 | 11 | 29490 | 41 | |||
138560 | 121561 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1044 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6003754 | 2102206 | 37.7524696725481 | -122.429902065263 | (37.7524696725481, -122.429902065263) | 2 | 4 | 5 | 28862 | 22 | |||
32689 | 108945 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 105 Richland Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | 2 | 7 | 7 | 28859 | 2 | |||||
76306 | 108943 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 105 Richland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | 2 | 7 | 7 | 28859 | 2 | |||||
57390 | 9617 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1050X Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6002921.99888 | 2111973.13636 | 37.7792406996886 | -122.433477183837 | (37.7792406996886, -122.433477183837) | 15 | 9 | 11 | 29490 | 41 | |||
69526 | 9615 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1050X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6002927.21435 | 2111923.58629 | 37.7791049434867 | -122.433455599491 | (37.7791049434867, -122.433455599491) | 15 | 9 | 11 | 29490 | 41 | |||
168453 | 17019 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1053 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001967.47701 | 2109780.334 | 37.7731656122234 | -122.436622263598 | (37.7731656122234, -122.436622263598) | 15 | 5 | 11 | 29492 | 9 | |||
52966 | 66275 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1065 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1990 12:00:00 AM | 3x3 | Permit Number 768678 | 6007678.31560988 | 2109516.6646006 | 37.7727645184447 | -122.416848989215 | (37.7727645184447, -122.416848989215) | 8 | 2 | 9 | 28853 | 19 | ||
29680 | 65045 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1066 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2004 12:00:00 AM | Permit Number 45972 | 6007827.74406772 | 2119607.84984942 | 37.8004808586212 | -122.417047244449 | (37.8004808586212, -122.417047244449) | 5 | 1 | 1 | 308 | 32 | |||
61113 | 57802 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 107 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1988 12:00:00 AM | 8 | 3x3 | Permit Number 25561 | 6000622.33928566 | 2102551.03510935 | 37.7532392091702 | -122.440756591601 | (37.7532392091702, -122.440756591601) | 2 | 4 | 5 | 28862 | 22 | |
37194 | 4729 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1075 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6008196.257 | 2120907.29394 | 37.8040695291651 | -122.41586410452 | (37.8040695291651, -122.41586410452) | 5 | 1 | 10 | 308 | 32 | |||
57727 | 4728 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1075 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6008196.257 | 2120907.29394 | 37.8040695291651 | -122.41586410452 | (37.8040695291651, -122.41586410452) | 5 | 1 | 10 | 308 | 32 | |||
14444 | 7238 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1085 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4X4 | 6003353.84267 | 2112023.38614 | 37.7794031644909 | -122.431986847688 | (37.7794031644909, -122.431986847688) | 15 | 9 | 11 | 29490 | 41 | |||
144803 | 7239 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1085 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6003353.76677 | 2111995.41321 | 37.7793263534941 | -122.431985112237 | (37.7793263534941, -122.431985112237) | 15 | 9 | 11 | 29490 | 41 | |||
164124 | 57410 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 109 Wilmot St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/1976 12:00:00 AM | 15 | Permit Number 770100 | 6002753.5601 | 2114939.9175 | 37.7873771736852 | -122.434272041026 | (37.7873771736852, -122.434272041026) | 13 | 9 | 11 | 29490 | 27 | ||
172156 | 97109 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1095X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003187 | 2102045 | 37.7519954785262 | -122.431851350128 | (37.7519954785262, -122.431851350128) | 2 | 4 | 5 | 28862 | 22 | |||
175062 | 97110 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1095X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003193.9 | 2101874 | 37.751526344012 | -122.431815280512 | (37.751526344012, -122.431815280512) | 2 | 4 | 5 | 28862 | 22 | |||
29615 | 120137 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
41773 | 120139 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
59516 | 120135 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
120635 | 120140 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
129533 | 120143 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
135359 | 120138 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
168941 | 120136 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
180679 | 120134 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
182867 | 120141 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
186730 | 120142 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
85954 | 15110 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6014281.21891 | 2116519.09631 | 37.7923607834286 | -122.394499049528 | (37.7923607834286, -122.394499049528) | 12 | 2 | 9 | 28855 | 6 | |||
111958 | 15109 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6014295.34515 | 2116528.26215 | 37.7923867359811 | -122.3944508141 | (37.7923867359811, -122.3944508141) | 12 | 2 | 9 | 28855 | 6 | |||
115493 | 15108 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6014309.51773 | 2116539.1619 | 37.7924174520023 | -122.394402539761 | (37.7924174520023, -122.394402539761) | 12 | 2 | 9 | 28855 | 6 | |||
124192 | 15106 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6014335.21568 | 2116559.29701 | 37.7924741668095 | -122.394315033873 | (37.7924741668095, -122.394315033873) | 12 | 2 | 9 | 28855 | 6 | |||
163880 | 15107 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6014322.84653 | 2116550.95179 | 37.7924505652168 | -122.394357247259 | (37.7924505652168, -122.394357247259) | 12 | 2 | 9 | 28855 | 6 | |||
175879 | 15105 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6014344.93761 | 2116565.97781 | 37.7924930511311 | -122.394281863407 | (37.7924930511311, -122.394281863407) | 12 | 2 | 9 | 28855 | 6 | |||
79471 | 59271 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2017 12:00:00 AM | 3 | Permit Number 18607 | 6004280.88948873 | 2109181.36087728 | 37.7716521728269 | -122.428577162778 | (37.7716521728269, -122.428577162778) | 7 | 9 | 11 | 28852 | 10 | ||
163074 | 110027 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1101X WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6003707 | 2112516 | 37.7807757743573 | -122.430800292528 | (37.7807757743573, -122.430800292528) | 15 | 9 | 11 | 29490 | 41 | ||||
102388 | 113158 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1104 STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997339 | 2106686 | 37.764405251212 | -122.452409351598 | (37.764405251212, -122.452409351598) | 15 | 5 | 11 | 29492 | 9 | ||||
117076 | 102235 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1104 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009987 | 2102770 | 37.7543693005663 | -122.408386989199 | (37.7543693005663, -122.408386989199) | 2 | 4 | 7 | 28859 | 19 | ||||
81702 | 93042 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110X Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6000798.7 | 2105708.1 | 37.7619177818182 | -122.440373100603 | (37.7619177818182, -122.440373100603) | 15 | 5 | 5 | 28862 | 3 | |||
153620 | 93043 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110X Ord St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6000798.7 | 2105708.1 | 37.7619177818182 | -122.440373100603 | (37.7619177818182, -122.440373100603) | 15 | 5 | 5 | 28862 | 3 | |||
121725 | 22672 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1115X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6003756.1555 | 2112617.12958 | 37.7810562358648 | -122.430637458337 | (37.7810562358648, -122.430637458337) | 15 | 9 | 11 | 29490 | 41 | |||
82935 | 39773 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 112 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/2001 12:00:00 AM | 14 | 6x6 | Permit Number 41140 | 6005154.17276637 | 2099634.09116827 | 37.7454869972987 | -122.424877067697 | (37.7454869972987, -122.424877067697) | 2 | 7 | 5 | 63 | 22 |
116920 | 39774 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 112 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/1999 12:00:00 AM | 14 | 5.5x6 | Permit Number 41140 | 6005154.17276637 | 2099634.09116827 | 37.7454869972987 | -122.424877067697 | (37.7454869972987, -122.424877067697) | 2 | 7 | 5 | 63 | 22 | |
32743 | 22671 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1140X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6003752.72615 | 2112639.82159 | 37.7811183481869 | -122.430650941901 | (37.7811183481869, -122.430650941901) | 15 | 9 | 11 | 29490 | 41 | |||
10358 | 120965 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1145x Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003243 | 2101623 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | 2 | 4 | 5 | 28862 | 22 | ||||
43513 | 120964 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1145x Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003243 | 2101623 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | 2 | 4 | 5 | 28862 | 22 | ||||
140782 | 120966 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1145x Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003243 | 2101623 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | 2 | 4 | 5 | 28862 | 22 | ||||
38950 | 93145 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1152 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991985 | 2113459 | 37.7826938870859 | -122.471420727494 | (37.7826938870859, -122.471420727494) | 11 | 6 | 2 | 54 | 11 | |||||
105841 | 93144 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1152 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2016 12:00:00 AM | 3 | 5991985 | 2113459 | 37.7826938870859 | -122.471420727494 | (37.7826938870859, -122.471420727494) | 11 | 6 | 2 | 54 | 11 | |||
149202 | 93146 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1152 Clement St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991985 | 2113459 | 37.7826938870859 | -122.471420727494 | (37.7826938870859, -122.471420727494) | 11 | 6 | 2 | 54 | 11 | |||||
166398 | 9620 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1165X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1990 12:00:00 AM | 50 | 3X3 | 6002862.99505 | 2112096.1743 | 37.779575183286 | -122.433690098242 | (37.779575183286, -122.433690098242) | 15 | 9 | 11 | 29490 | 41 | ||
44254 | 20167 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1175 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 4X4 | 6002828.6579039 | 2112263.6806979 | 37.7800331654734 | -122.433820860908 | (37.7800331654734, -122.433820860908) | 15 | 9 | 11 | 29490 | 41 | |||
31137 | 4747 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1199X Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3X4 | 6007816.30894 | 2121179.41413 | 37.8047953349468 | -122.417198239329 | (37.8047953349468, -122.417198239329) | 5 | 1 | 1 | 308 | 32 | |||
138529 | 4746 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1199X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X4 | 6007816.30894 | 2121179.41413 | 37.8047953349468 | -122.417198239329 | (37.8047953349468, -122.417198239329) | 5 | 1 | 1 | 308 | 32 | |||
36076 | 111627 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11X SOUTH VAN NESS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007074 | 2110234 | 37.7747001403616 | -122.418990277193 | (37.7747001403616, -122.418990277193) | 8 | 2 | 9 | 28853 | 19 | ||||
38468 | 111626 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11X SOUTH VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007074 | 2110234 | 37.7747001403616 | -122.418990277193 | (37.7747001403616, -122.418990277193) | 8 | 2 | 9 | 28853 | 19 | ||||
183049 | 111628 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11X SOUTH VAN NESS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007074 | 2110234 | 37.7747001403616 | -122.418990277193 | (37.7747001403616, -122.418990277193) | 8 | 2 | 9 | 28853 | 19 | ||||
141056 | 121371 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11x Seymour St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001614 | 2112138 | 37.7796190766925 | -122.438013896478 | (37.7796190766925, -122.438013896478) | 15 | 5 | 11 | 29490 | 41 | ||||
147215 | 121369 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11x Seymour St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001614 | 2112138 | 37.7796190766925 | -122.438013896478 | (37.7796190766925, -122.438013896478) | 15 | 5 | 11 | 29490 | 41 | ||||
25734 | 113701 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 12 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6007151 | 2099622 | 37.7455663833026 | -122.417971480149 | (37.7455663833026, -122.417971480149) | 2 | 7 | 7 | 28859 | 2 | |||
110718 | 113188 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 12 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x12 | 6007151 | 2099622 | 37.7455663833026 | -122.417971480149 | (37.7455663833026, -122.417971480149) | 2 | 7 | 7 | 28859 | 2 | |||
65361 | 17049 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1209 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001136.98076 | 2109644.95458 | 37.7727466639243 | -122.439485345621 | (37.7727466639243, -122.439485345621) | 15 | 5 | 11 | 29492 | 9 | |||
19484 | 77283 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1210 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6001986.2323 | 2110871.5472 | 37.7761628769629 | -122.436635509753 | (37.7761628769629, -122.436635509753) | 15 | 5 | 11 | 29492 | 10 | |||
135459 | 106967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1225 02ND AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995419.1 | 2107212.6 | 37.7657409782079 | -122.459087842629 | (37.7657409782079, -122.459087842629) | 15 | 5 | 11 | 56 | 12 | ||||||
100953 | 8184 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1225 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001879.34509 | 2111133.55167 | 37.7768762007109 | -122.437024023016 | (37.7768762007109, -122.437024023016) | 15 | 5 | 11 | 29492 | 10 | |||
94460 | 101975 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1230 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769454 | 6013882 | 2105282.2 | 37.7614846061652 | -122.395092936828 | (37.7614846061652, -122.395092936828) | 10 | 3 | 8 | 28856 | 29 | |||
92133 | 62276 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 124 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/1985 12:00:00 AM | 13 | 21x6 | Permit Number 22414 | 6003841.87853288 | 2108837.79837285 | 37.7706839798213 | -122.430071215032 | (37.7706839798213, -122.430071215032) | 7 | 9 | 11 | 29492 | 10 | |
124630 | 54736 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1247 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/1993 12:00:00 AM | 12 | 5x5 | Permit Number 31998 | 5994208.55249488 | 2107032.01090972 | 37.7651754625969 | -122.463261729084 | (37.7651754625969, -122.463261729084) | 11 | 5 | 11 | 56 | 12 | |
170119 | 103480 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1247 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x5 | Permit Number 31998 | 5994182.5 | 2107061.8 | 37.765255754741 | -122.463353999562 | (37.765255754741, -122.463353999562) | 11 | 5 | 11 | 56 | 12 | ||
140268 | 54410 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1248 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | Permit Number 10182 | 5993332.64911234 | 2106987.54521442 | 37.765002872173 | -122.46628801063 | (37.765002872173, -122.46628801063) | 11 | 8 | 11 | 56 | 12 | |||
58111 | 258045 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6007719 | 2121534 | 37.805763462997 | -122.417560134413 | (37.805763462997, -122.417560134413) | 5 | 1 | 10 | 308 | 23 | ||
150358 | 258047 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6007719 | 2121534 | 37.805763462997 | -122.417560134413 | (37.805763462997, -122.417560134413) | 5 | 1 | 10 | 308 | 23 | ||
168220 | 258046 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6007719 | 2121534 | 37.805763462997 | -122.417560134413 | (37.805763462997, -122.417560134413) | 5 | 1 | 10 | 308 | 23 | ||
27991 | 97561 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1251X 04th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5994791.4 | 2106981 | 37.7650689602603 | -122.461242116604 | (37.7650689602603, -122.461242116604) | 15 | 5 | 11 | 56 | 12 | ||||
74524 | 95408 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1257 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | No record of tree being permitted for planting. | 6006989.2 | 2119073.6 | 37.7989667366731 | -122.419911018667 | (37.7989667366731, -122.419911018667) | 5 | 1 | 10 | 28858 | 32 | ||
91220 | 120660 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 126 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
49452 | 86740 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1275 02nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49708 | 5995441.8 | 2106872.8 | 37.7648092803065 | -122.458984723243 | (37.7648092803065, -122.458984723243) | 15 | 5 | 11 | 56 | 12 | |||||
192777 | 48866 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 129 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2002 12:00:00 AM | Permit Number 46075 | 6006370.62112219 | 2110394.65908683 | 37.7751016387897 | -122.421434823029 | (37.7751016387897, -122.421434823029) | 7 | 9 | 11 | 28852 | 10 | |||
66858 | 173948 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1300 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999106 | 2105162 | 37.7603218028196 | -122.446188178838 | (37.7603218028196, -122.446188178838) | 15 | 5 | 5 | 28862 | 3 | ||||
75176 | 173949 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1306 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999102 | 2105133 | 37.7602419475954 | -122.446199926833 | (37.7602419475954, -122.446199926833) | 15 | 5 | 5 | 28862 | 3 | ||||
79333 | 33008 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1311 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | 6x4 | Permit Number 37302 | 5994224.05093468 | 2106581.50911401 | 37.7639393951455 | -122.463175433011 | (37.7639393951455, -122.463175433011) | 1 | 5 | 11 | 56 | 12 | ||
128105 | 109334 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1313 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5999032 | 2105350 | 37.7608337776961 | -122.446457634643 | (37.7608337776961, -122.446457634643) | 15 | 5 | 5 | 28862 | 12 | |||
27436 | 107660 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1316 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999083.9 | 2105040.7 | 37.7599874810533 | -122.446255886285 | (37.7599874810533, -122.446255886285) | 15 | 5 | 5 | 28862 | 3 | |||
94921 | 109333 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1317 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 5999055 | 2105304 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | 15 | 5 | 5 | 28862 | 12 | |||
118732 | 117200 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1321 23RD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5988915 | 2106334 | 37.7629525336189 | -122.481519510385 | (37.7629525336189, -122.481519510385) | 1 | 8 | 3 | 56 | 35 | |||
188517 | 109332 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1321 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5998933 | 2105018 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | 15 | 5 | 5 | 28862 | 12 |
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) );