trees
390 rows where qSpecies_id = 126 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9874 | 199550 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 6 | : Yard | Tree | Private 2 | 15 | 6014401.0054 | 2105922.09622 | 37.7632704697749 | -122.393342678542 | (37.7632704697749, -122.393342678542) | 14 | 3 | 8 | 28856 | 29 | ||||
35282 | 199555 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 15 | : Yard | Tree | Private 2 | 8 | 6014446.64039 | 2105914.65899 | 37.7632525840546 | -122.393184320496 | (37.7632525840546, -122.393184320496) | 14 | 3 | 8 | 28856 | 29 | ||||
47998 | 199553 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 9 | : Yard | Tree | Private 2 | 20 | 6014424.93308 | 2105923.01259 | 37.7632743152759 | -122.393259984074 | (37.7632743152759, -122.393259984074) | 14 | 3 | 8 | 28856 | 29 | ||||
51970 | 199546 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 2 | : Yard | Tree | Private 2 | 8 | 6014366.09507 | 2105920.56167 | 37.7632643166198 | -122.393463315392 | (37.7632643166198, -122.393463315392) | 14 | 3 | 8 | 28856 | 29 | ||||
61178 | 199557 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 18 | : Yard | Tree | Private 2 | 9 | 6014448.03527 | 2105905.59327 | 37.7632277690557 | -122.393178861636 | (37.7632277690557, -122.393178861636) | 14 | 3 | 8 | 28856 | 29 | ||||
65739 | 199548 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 4 | : Yard | Tree | Private 2 | 9 | 6014382.11605 | 2105919.95745 | 37.7632635477036 | -122.393407861395 | (37.7632635477036, -122.393407861395) | 14 | 3 | 8 | 28856 | 29 | ||||
90528 | 199552 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 8 | : Yard | Tree | Private 2 | 15 | 6014417.3246 | 2105922.3261 | 37.7632720076265 | -122.393286251461 | (37.7632720076265, -122.393286251461) | 14 | 3 | 8 | 28856 | 29 | ||||
93012 | 199547 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 3 | : Yard | Tree | Private 2 | 15 | 6014373.91679 | 2105917.88241 | 37.7632573945418 | -122.393436074922 | (37.7632573945418, -122.393436074922) | 14 | 3 | 8 | 28856 | 29 | ||||
101340 | 199556 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 17 | : Yard | Tree | Private 2 | 4 | 6014441.57524 | 2105911.35616 | 37.7632432338158 | -122.393201608186 | (37.7632432338158, -122.393201608186) | 14 | 3 | 8 | 28856 | 29 | ||||
125405 | 199545 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 1 | : Yard | Tree | Private 2 | 12 | 6014356.43896 | 2105915.99545 | 37.7632512422621 | -122.393496393361 | (37.7632512422621, -122.393496393361) | 14 | 3 | 8 | 28856 | 29 | ||||
131658 | 199554 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 10 | : Yard | Tree | Private 2 | 17 | 6014431.68682 | 2105923.15598 | 37.7632750842003 | -122.393236634966 | (37.7632750842003, -122.393236634966) | 14 | 3 | 8 | 28856 | 29 | ||||
155531 | 199551 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 7 | : Yard | Tree | Private 2 | 15 | 6014408.59689 | 2105921.94262 | 37.7632704697891 | -122.393316411129 | (37.7632704697891, -122.393316411129) | 14 | 3 | 8 | 28856 | 29 | ||||
168884 | 199549 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 5 | : Yard | Tree | Private 2 | 9 | 6014392.26095 | 2105920.87265 | 37.7632666242892 | -122.393372837314 | (37.7632666242892, -122.393372837314) | 14 | 3 | 8 | 28856 | 29 | ||||
33914 | 202077 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 6 | Front Yard : Yard | Tree | Private 2 | 9 | 6012700.16365 | 2090713.41208 | 37.721416000129 | -122.398158307957 | (37.721416000129, -122.398158307957) | 10 | 3 | 8 | 58 | 1 | ||||
46515 | 202076 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 5 | Front Yard : Yard | Tree | Private 2 | 18 | 6012694.00092 | 2090696.52405 | 37.7213692857431 | -122.398178426718 | (37.7213692857431, -122.398178426718) | 10 | 3 | 8 | 58 | 1 | ||||
114215 | 202075 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 4 | Front Yard : Yard | Tree | Private 2 | 18 | 6012687.55592 | 2090674.96794 | 37.7213097380253 | -122.398199193847 | (37.7213097380253, -122.398199193847) | 10 | 3 | 8 | 58 | 1 | ||||
131503 | 202074 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 3 | Front Yard : Yard | Tree | Private 2 | 18 | 6012682.24985 | 2090663.29707 | 37.7212773966172 | -122.398216717151 | (37.7212773966172, -122.398216717151) | 10 | 3 | 8 | 58 | 1 | ||||
157827 | 202079 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 8 | Front Yard : Yard | Tree | Private 2 | 10 | 6012746.01501 | 2090845.03433 | 37.721779962063 | -122.398009040306 | (37.721779962063, -122.398009040306) | 10 | 3 | 8 | 58 | 1 | ||||
98470 | 217498 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Malta Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5999813.4338 | 2095843.99657 | 37.7347771864063 | -122.443072299949 | (37.7347771864063, -122.443072299949) | 9 | 7 | 4 | 63 | 40 | |||
142381 | 217497 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Malta Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 5999813.58139 | 2095851.10387 | 37.7347967097977 | -122.44307229994 | (37.7347967097977, -122.44307229994) | 9 | 7 | 4 | 63 | 40 | |||
82713 | 26914 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 10 Caine Ave | 10 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 5997577.15723 | 2089606.82913 | 37.7175236335794 | -122.450354374056 | (37.7175236335794, -122.450354374056) | 9 | 8 | 6 | 28861 | 24 | |||
90258 | 217532 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 10 Caine Ave | 12 | : | Tree | Private 2 | 4 | Width 0ft | 5997565.18295 | 2089591.75195 | 37.7174815498251 | -122.450394677186 | (37.7174815498251, -122.450394677186) | 9 | 8 | 6 | 28861 | 24 | |||
105503 | 142406 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 10 MAYFAIR DR | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5997813.4721 | 2114548.5306 | 37.7860208967808 | -122.451335398225 | (37.7860208967808, -122.451335398225) | 11 | 6 | 1 | 54 | 31 | |||
116287 | 217509 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 100 Gennessee St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 1ft | 5997469.91402 | 2093889.34783 | 37.7292762870588 | -122.45103370846 | (37.7292762870588, -122.45103370846) | 9 | 7 | 4 | 28861 | 40 | |||
184227 | 243966 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1001 San Jose Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 10ft | 6005137.774 | 2096747.60933 | 37.7375604469531 | -122.424728467557 | (37.7375604469531, -122.424728467557) | 2 | 7 | 5 | 28859 | 2 | |||
65066 | 199529 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1002 Pennsylvania Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 8ft | 6014459.21941 | 2102468.19683 | 37.7537900415949 | -122.392899675174 | (37.7537900415949, -122.392899675174) | 10 | 3 | 8 | 28856 | 29 | |||
91673 | 181300 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Nueva Ave | 3 | Front Yard : Yard | Tree | Private 2 | 48 | Width 4ft | 6013063.40285 | 2087533.07945 | 37.7127036658128 | -122.396679845022 | (37.7127036658128, -122.396679845022) | 10 | 3 | 8 | 58 | 1 | |||
92728 | 181301 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Nueva Ave | 4 | Front Yard : Yard | Tree | Private 2 | 4 | Width 4ft | 6013065.73831 | 2087544.18077 | 37.7127342778318 | -122.396672550617 | (37.7127342778318, -122.396672550617) | 10 | 3 | 8 | 58 | 1 | |||
93876 | 181302 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Nueva Ave | 5 | Front Yard : Yard | Tree | Private 2 | 4 | Width 4ft | 6013064.24149 | 2087553.26 | 37.7127591242993 | -122.396678360222 | (37.7127591242993, -122.396678360222) | 10 | 3 | 8 | 58 | 1 | |||
180454 | 181303 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Nueva Ave | 6 | Front Yard : Yard | Tree | Private 2 | 15 | Width 4ft | 6013062.58437 | 2087561.0422 | 37.712780400456 | -122.396684633014 | (37.712780400456, -122.396684633014) | 10 | 3 | 8 | 58 | 1 | |||
3048 | 199537 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 16 | Front Yard : Yard | Tree | Private 2 | 4 | 6014323.98726 | 2106464.8847 | 37.7647565688948 | -122.393647053167 | (37.7647565688948, -122.393647053167) | 14 | 3 | 8 | 310 | 29 | ||||
17458 | 199543 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 38 | Front Yard : Yard | Tree | Private 2 | 5 | 6014244.47574 | 2106692.17431 | 37.7653762377352 | -122.393937976682 | (37.7653762377352, -122.393937976682) | 14 | 3 | 8 | 28856 | 20 | ||||
26871 | 199533 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 6 | Front Yard : Yard | Tree | Private 2 | 4 | 6014329.6983 | 2106362.34828 | 37.7644753436933 | -122.393620122984 | (37.7644753436933, -122.393620122984) | 14 | 3 | 8 | 310 | 29 | ||||
55653 | 199539 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 29 | Front Yard : Yard | Tree | Private 2 | 4 | 6014306.32543 | 2106588.22491 | 37.7650942526332 | -122.393716774935 | (37.7650942526332, -122.393716774935) | 14 | 3 | 8 | 310 | 29 | ||||
68930 | 199541 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 34 | Front Yard : Yard | Tree | Private 2 | 4 | 6014267.9908 | 2106682.1532 | 37.7653500288033 | -122.393855941398 | (37.7653500288033, -122.393855941398) | 14 | 3 | 8 | 310 | 20 | ||||
96396 | 199538 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 18 | Front Yard : Yard | Tree | Private 2 | 4 | 6014323.67037 | 2106494.67035 | 37.7648383361526 | -122.393650234094 | (37.7648383361526, -122.393650234094) | 14 | 3 | 8 | 310 | 29 | ||||
99328 | 199535 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 10 | Front Yard : Yard | Tree | Private 2 | 6 | 6014327.91583 | 2106402.88098 | 37.7645865385638 | -122.393629125195 | (37.7645865385638, -122.393629125195) | 14 | 3 | 8 | 310 | 29 | ||||
102062 | 199542 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 36 | Front Yard : Yard | Tree | Private 2 | 9 | 6014252.51342 | 2106695.17949 | 37.7653849359952 | -122.393910386379 | (37.7653849359952, -122.393910386379) | 14 | 3 | 8 | 28856 | 20 | ||||
107083 | 199540 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 31 | Front Yard : Yard | Tree | Private 2 | 4 | 6014294.90001 | 2106622.244 | 37.765187026683 | -122.393758674316 | (37.765187026683, -122.393758674316) | 14 | 3 | 8 | 310 | 29 | ||||
140910 | 199534 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 7 | Front Yard : Yard | Tree | Private 2 | 7 | 6014328.93233 | 2106372.73104 | 37.7645038099161 | -122.393623499025 | (37.7645038099161, -122.393623499025) | 14 | 3 | 8 | 310 | 29 | ||||
145630 | 199544 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 42 | Front Yard : Yard | Tree | Private 2 | 4 | 6014223.58604 | 2106699.16409 | 37.7653942691555 | -122.394010719216 | (37.7653942691555, -122.394010719216) | 14 | 3 | 8 | 28856 | 20 | ||||
157486 | 199536 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 13 | Front Yard : Yard | Tree | Private 2 | 4 | 6014326.65854 | 2106427.77469 | 37.7646548213741 | -122.3936352163 | (37.7646548213741, -122.3936352163) | 14 | 3 | 8 | 310 | 29 | ||||
193936 | 200175 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1022 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6013884.9652 | 2089743.6718 | 37.7188192082582 | -122.393994895467 | (37.7188192082582, -122.393994895467) | 10 | 3 | 8 | 58 | 1 | |||
73061 | 200489 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1086 Jamestown Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 6013557.4449 | 2089988.7054 | 37.7194738134712 | -122.395144165456 | (37.7194738134712, -122.395144165456) | 10 | 3 | 8 | 58 | 1 | |||
8435 | 199530 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1091 19th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6014489.75504 | 2105264.07428 | 37.7614686151109 | -122.392989678445 | (37.7614686151109, -122.392989678445) | 10 | 3 | 8 | 28856 | 29 | ||||
60244 | 199531 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1098 19th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6014488.94971 | 2105281.88683 | 37.7615174797697 | -122.392993710091 | (37.7615174797697, -122.392993710091) | 10 | 3 | 8 | 28856 | 29 | ||||
77734 | 199532 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1098 19th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 6014487.32888 | 2105297.7815 | 37.7615610330466 | -122.393000428053 | (37.7615610330466, -122.393000428053) | 10 | 3 | 8 | 28856 | 29 | ||||
150653 | 243967 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1100 San Jose Ave | 11 | Front Yard : Yard | Tree | Private 2 | 5 | 6004821.13664 | 2096702.54492 | 37.7374188217218 | -122.425820026897 | (37.7374188217218, -122.425820026897) | 2 | 7 | 5 | 63 | 7 | ||||
181626 | 199521 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1112 Tennessee St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 58 | Width 6ft | 6015518.58105 | 2103812.19357 | 37.7575391569355 | -122.389329974622 | (37.7575391569355, -122.389329974622) | 10 | 3 | 8 | 28856 | 29 | |||
76368 | 104212 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1117 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 6012239.80468 | 2103199.03133 | 37.7556732255654 | -122.400626303066 | (37.7556732255654, -122.400626303066) | 10 | 3 | 8 | 28856 | 29 | ||||
59861 | 199522 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1150x Tennessee St | 3 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6015555.37035 | 2103675.62885 | 37.7571662188511 | -122.389193205711 | (37.7571662188511, -122.389193205711) | 10 | 3 | 8 | 28856 | 29 | |||
174323 | 199523 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1150x Tennessee St | 4 | Median : Cutout | Tree | DPW 1 | 9 | Width 4ft | 6015556.62319 | 2103663.95863 | 37.7571342443646 | -122.389188058008 | (37.7571342443646, -122.389188058008) | 10 | 3 | 8 | 28856 | 29 | |||
57391 | 243968 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1200 San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 6 | 6004061.61432 | 2095990.9181 | 37.7354219049951 | -122.428395344371 | (37.7354219049951, -122.428395344371) | 2 | 7 | 5 | 63 | 7 | ||||
33081 | 243978 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 76 | Front Yard : Yard | Tree | Private 2 | 4 | 6004588.46206 | 2096170.32088 | 37.7359443031923 | -122.426586604496 | (37.7359443031923, -122.426586604496) | 2 | 7 | 5 | 28861 | 2 | ||||
60644 | 243977 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 74 | Front Yard : Yard | Tree | Private 2 | 21 | 6004578.54944 | 2096162.87225 | 37.7359232905307 | -122.426620346145 | (37.7359232905307, -122.426620346145) | 2 | 7 | 5 | 28861 | 2 | ||||
91156 | 243980 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 79 | Front Yard : Yard | Tree | Private 2 | 6 | 6004603.12758 | 2096184.79771 | 37.7359848823907 | -122.426536930441 | (37.7359848823907, -122.426536930441) | 2 | 7 | 5 | 28861 | 2 | ||||
98598 | 243976 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 70 | Front Yard : Yard | Tree | Private 2 | 18 | 6004556.64322 | 2096143.57753 | 37.7358690730924 | -122.426694711107 | (37.7358690730924, -122.426694711107) | 2 | 7 | 5 | 28861 | 2 | ||||
144256 | 243981 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 80 | Front Yard : Yard | Tree | Private 2 | 11 | 6004609.84648 | 2096189.0617 | 37.7359969701789 | -122.426514004025 | (37.7359969701789, -122.426514004025) | 2 | 7 | 5 | 28861 | 2 | ||||
178235 | 243979 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 78 | Front Yard : Yard | Tree | Private 2 | 13 | 6004594.17707 | 2096179.38026 | 37.735969501297 | -122.426567490311 | (37.735969501297, -122.426567490311) | 2 | 7 | 5 | 28861 | 2 | ||||
130546 | 217492 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1211 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5991111.74461 | 2105172.65449 | 37.7598912734774 | -122.473837074718 | (37.7598912734774, -122.473837074718) | 1 | 8 | 4 | 56 | 12 | |||
76379 | 217491 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1213 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 5991098.23401 | 2105172.09937 | 37.7598889667237 | -122.473883760333 | (37.7598889667237, -122.473883760333) | 1 | 8 | 4 | 56 | 12 | |||
32789 | 32956 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1218 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 12 | 3x8 | Permit Number 37270 | 6013588.68321 | 2106187.45016 | 37.7639539086769 | -122.396170851203 | (37.7639539086769, -122.396170851203) | 14 | 3 | 8 | 28856 | 29 |
113310 | 217490 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1219 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5991058.25824 | 2105170.14194 | 37.759881276613 | -122.474021872835 | (37.759881276613, -122.474021872835) | 1 | 8 | 4 | 56 | 12 | |||
71941 | 199560 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1224 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6013565.3857 | 2106186.89187 | 37.763951079408 | -122.39625139179 | (37.763951079408, -122.39625139179) | 14 | 3 | 8 | 28856 | 29 | |||
24638 | 199569 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1236 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6012213.10584 | 2102625.8594 | 37.7540979317002 | -122.400678372936 | (37.7540979317002, -122.400678372936) | 10 | 3 | 8 | 28856 | 29 | |||
17619 | 61510 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1237 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1984 12:00:00 AM | 23 | Permit Number 21466 | 6012274.20726 | 2102601.29078 | 37.754033879279 | -122.400465342406 | (37.754033879279, -122.400465342406) | 10 | 3 | 8 | 28856 | 29 | |
30312 | 217517 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 124 Marston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5998604.94971 | 2093225.36447 | 37.7275180612089 | -122.447062041474 | (37.7275180612089, -122.447062041474) | 9 | 7 | 4 | 28861 | 40 | ||||
131609 | 217516 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 124 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998607.55261 | 2093227.99671 | 37.7275254374392 | -122.447053232615 | (37.7275254374392, -122.447053232615) | 9 | 7 | 4 | 28861 | 40 | ||||
172208 | 217518 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 124 Marston Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998600.75769 | 2093225.60072 | 37.7275184703858 | -122.447076550251 | (37.7275184703858, -122.447076550251) | 9 | 7 | 4 | 28861 | 40 | ||||
122681 | 217519 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 125 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 94 | Width 10ft | 5998618.10798 | 2093180.61105 | 37.7273959305753 | -122.447013334218 | (37.7273959305753, -122.447013334218) | 9 | 7 | 4 | 28861 | 40 | |||
8542 | 73713 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1265 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 27 | 6012277.51673 | 2102506.08306 | 37.7537726442006 | -122.400447210275 | (37.7537726442006, -122.400447210275) | 10 | 3 | 8 | 28856 | 29 | |||
28529 | 199578 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1275 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6012281.81813 | 2102445.37278 | 37.7536061868776 | -122.400428070902 | (37.7536061868776, -122.400428070902) | 10 | 3 | 8 | 28856 | 29 | |||
157103 | 217496 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 129 Merced Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994601.19154 | 2099478.10062 | 37.7444569673245 | -122.461356045958 | (37.7444569673245, -122.461356045958) | 1 | 8 | 4 | 59 | 40 | |||
75056 | 183314 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1298 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981216.5568 | 2106353.9637 | 37.7625567133131 | -122.508146779871 | (37.7625567133131, -122.508146779871) | 1 | 8 | 3 | 56 | 35 | |||
7873 | 74275 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 130 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010944.70013 | 2088154.7138 | 37.714292400951 | -122.404046514754 | (37.714292400951, -122.404046514754) | 9 | 7 | 8 | 309 | 39 | |||
18569 | 74063 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 130 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010946.7362 | 2088147.19919 | 37.7142718811123 | -122.404038948741 | (37.7142718811123, -122.404038948741) | 9 | 7 | 8 | 309 | 39 | |||
100487 | 199576 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1300x De Haro St | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 6ft | 6012291.12869 | 2102166.26661 | 37.7528403413075 | -122.40037626996 | (37.7528403413075, -122.40037626996) | 10 | 3 | 8 | 28856 | 29 | |||
108225 | 199577 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1300x De Haro St | 3 | Median : Yard | Tree | DPW 1 | 15 | 6012278.40127 | 2102219.77174 | 37.7529865450046 | -122.400424041944 | (37.7529865450046, -122.400424041944) | 10 | 3 | 8 | 28856 | 29 | ||||
142592 | 199574 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1300x De Haro St | 33 | Median : Yard | Tree | DPW 1 | 35 | 6012273.26957 | 2101981.44078 | 37.7523318538423 | -122.400425049202 | (37.7523318538423, -122.400425049202) | 10 | 3 | 8 | 28856 | 29 | ||||
193806 | 199575 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1300x De Haro St | 25 | Median : Yard | Tree | DPW 1 | 27 | 6012270.74731 | 2102100.89416 | 37.7526597061983 | -122.400442161487 | (37.7526597061983, -122.400442161487) | 10 | 3 | 8 | 28856 | 29 | ||||
9401 | 244003 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1301 Douglass St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 4ft | 6001394.33325 | 2099880.52449 | 37.7459505586756 | -122.437895622392 | (37.7459505586756, -122.437895622392) | 2 | 4 | 5 | 63 | 22 | |||
88599 | 244004 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1301 Douglass St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 54 | Width 4ft | 6001393.00761 | 2099889.10115 | 37.7459740327688 | -122.437900820469 | (37.7459740327688, -122.437900820469) | 2 | 4 | 5 | 63 | 22 | |||
16924 | 199525 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1301 Minnesota St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6015396.88376 | 2102219.87285 | 37.7531602346611 | -122.389639647178 | (37.7531602346611, -122.389639647178) | 10 | 3 | 8 | 28856 | 29 | ||||
119513 | 244011 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1327 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 70 | Width 10ft | 6002019.91281 | 2100146.50257 | 37.746716425824 | -122.435751483069 | (37.746716425824, -122.435751483069) | 2 | 7 | 5 | 63 | 22 | |||
180429 | 244012 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1327 Diamond St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 85 | Width 10ft | 6002018.1444 | 2100161.75754 | 37.7467582119217 | -122.435758689308 | (37.7467582119217, -122.435758689308) | 2 | 7 | 5 | 63 | 22 | |||
64013 | 199524 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1350 Indiana St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | 6015069.09228 | 2102280.3688 | 37.7533081623518 | -122.390777452343 | (37.7533081623518, -122.390777452343) | 10 | 3 | 8 | 28856 | 29 | ||||
78576 | 244002 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1351 Douglass St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 6ft | 6001401.78652 | 2099724.90862 | 37.7455236981732 | -122.437858706115 | (37.7455236981732, -122.437858706115) | 2 | 4 | 5 | 63 | 22 | |||
108656 | 4447 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1361 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6004544.06336 | 2100936.24099 | 37.7490279200058 | -122.42707946086 | (37.7490279200058, -122.42707946086) | 2 | 4 | 5 | 28862 | 22 | |||
32056 | 199570 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1399 De Haro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | 6012307.76781 | 2101930.26834 | 37.752193269208 | -122.40030215414 | (37.752193269208, -122.40030215414) | 10 | 3 | 8 | 28856 | 29 | ||||
52808 | 199571 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1399 De Haro St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | 6012297.36216 | 2101934.2505 | 37.7522036231042 | -122.400338418383 | (37.7522036231042, -122.400338418383) | 10 | 3 | 8 | 28856 | 29 | ||||
125020 | 199572 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1399 De Haro St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | 6012303.84438 | 2101937.88969 | 37.7522139769989 | -122.400316257304 | (37.7522139769989, -122.400316257304) | 10 | 3 | 8 | 28856 | 29 | ||||
174973 | 199573 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1399 De Haro St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | 6012315.17384 | 2101950.7126 | 37.7522498176817 | -122.400277978566 | (37.7522498176817, -122.400277978566) | 10 | 3 | 8 | 28856 | 29 | ||||
151620 | 246743 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 140 Ripley St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6008904.95931 | 2099075.94101 | 37.7441655842699 | -122.411867956365 | (37.7441655842699, -122.411867956365) | 2 | 7 | 7 | 28859 | 2 | ||||
81156 | 199597 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1400 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 65 | 6012249.42802 | 2101848.61895 | 37.7519658243772 | -122.400498168571 | (37.7519658243772, -122.400498168571) | 10 | 3 | 8 | 28856 | 29 | ||||
109463 | 199598 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1400 De Haro St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 65 | 6012249.21193 | 2101837.97965 | 37.7519365991191 | -122.400498168573 | (37.7519365991191, -122.400498168573) | 10 | 3 | 8 | 28856 | 29 | ||||
122473 | 217522 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 143 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5995315.51814 | 2090865.8028 | 37.7208507807174 | -122.458262844852 | (37.7208507807174, -122.458262844852) | 9 | 8 | 6 | 28861 | 24 | |||
25333 | 199595 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1441 Rhode Island St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6012041.40362 | 2101659.26991 | 37.7514343097479 | -122.401204246987 | (37.7514343097479, -122.401204246987) | 10 | 3 | 8 | 28856 | 29 | ||||
178286 | 199594 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1441 Rhode Island St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6012053.10974 | 2101657.49367 | 37.751430085644 | -122.401163640783 | (37.751430085644, -122.401163640783) | 10 | 3 | 8 | 28856 | 29 | |||
140547 | 217488 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1444 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 5991174.83832 | 2105560.10023 | 37.7609587507553 | -122.473647129814 | (37.7609587507553, -122.473647129814) | 1 | 8 | 4 | 56 | 12 | |||
193438 | 199593 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1451 Rhode Island St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6012044.93423 | 2101620.11846 | 37.7513270053431 | -122.40118928678 | (37.7513270053431, -122.40118928678) | 10 | 3 | 8 | 28856 | 29 |
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) );