trees
390 rows where qSpecies_id = 126 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68842 | 243984 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2700 18th St | 4 | : | Tree | Private 2 | 11 | Width 2ft | 6009760.35156 | 2105514.40218 | 37.7618921157423 | -122.409364464996 | (37.7618921157423, -122.409364464996) | 8 | 4 | 8 | 28859 | 19 | |||
73318 | 243985 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2700 18th St | 6 | : | Tree | Private 2 | 11 | Width 2ft | 6009720.47366 | 2105510.67179 | 37.7618796385691 | -122.409502124237 | (37.7618796385691, -122.409502124237) | 8 | 4 | 8 | 28859 | 19 | |||
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 | |||
98780 | 243987 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3098 25th St | 1 | : | Tree | Private 2 | 21 | Width 3ft | 6009038.63911 | 2101607.11758 | 37.7511231326358 | -122.411584519713 | (37.7511231326358, -122.411584519713) | 2 | 4 | 7 | 28859 | 19 | |||
109756 | 137514 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3633 Webster St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6002566.08313 | 2121090.50651 | 37.8042544532535 | -122.435360804076 | (37.8042544532535, -122.435360804076) | 13 | 9 | 1 | 57 | 17 | |||
137217 | 201522 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 863 Innes Ave | 2 | : | Tree | Private 2 | 4 | Width 2ft | 6019436.46936 | 2094253.96379 | 37.7315105906351 | -122.375117750879 | (37.7315105906351, -122.375117750879) | 10 | 3 | 8 | 58 | 1 | |||
137633 | 181309 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3001 Ocean Ave | 2 | : | Tree | Private 2 | 4 | Width 3ft | 5989502.80382 | 2095226.84947 | 37.732489380377 | -122.478674182688 | (37.732489380377, -122.478674182688) | 1 | 8 | 4 | 64 | 35 | |||
144904 | 181310 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3001 Ocean Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 5989516.32728 | 2095227.01255 | 37.7324906133438 | -122.478627441312 | (37.7324906133438, -122.478627441312) | 1 | 8 | 4 | 64 | 35 | |||
170144 | 199607 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1515 19th St | 3 | : | Tree | Private 2 | 23 | Width 4ft | 6013161.794 | 2105177.42941 | 37.7611568525187 | -122.397576500574 | (37.7611568525187, -122.397576500574) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||||
77896 | 217537 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 89 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 18 | 5992163.63598 | 2088434.33055 | 37.7139929276052 | -122.468980989298 | (37.7139929276052, -122.468980989298) | 9 | 8 | 6 | 64 | 24 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
57688 | 199617 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1670 Armstrong Ave | 2 | Front Yard : Yard | Tree | Private 2 | 24 | 6013996.30242 | 2092813.56299 | 37.7272547028171 | -122.39382481138 | (37.7272547028171, -122.39382481138) | 10 | 3 | 8 | 58 | 1 | ||||
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 | ||||
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 | ||||
80861 | 243975 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 220 Coso Ave | 6 | Front Yard : Yard | Tree | Private 2 | 10 | 6007595.15715 | 2099522.63398 | 37.7453185340155 | -122.416428611787 | (37.7453185340155, -122.416428611787) | 2 | 7 | 7 | 28859 | 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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | ||||
108035 | 199601 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 22nd St | 18 | Front Yard : Yard | Tree | Private 2 | 15 | 6013350.80583 | 2103837.53278 | 37.757488311954 | -122.396828844671 | (37.757488311954, -122.396828844671) | 10 | 3 | 8 | 28856 | 29 | ||||
110592 | 247132 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 500 27th St | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 6003218.38287 | 2100061.52539 | 37.7465511016707 | -122.431601230532 | (37.7465511016707, -122.431601230532) | 2 | 7 | 5 | 63 | 22 | ||||
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 | ||||
120379 | 199567 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 580 De Haro St | 12 | Front Yard : Yard | Tree | Private 2 | 4 | Width 5ft | 6012037.95559 | 2105660.50299 | 37.7624206230271 | -122.401497351342 | (37.7624206230271, -122.401497351342) | 8 | 3 | 8 | 28856 | 29 | |||
122630 | 199621 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2330 Lane St | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 6013971.3633 | 2092946.01515 | 37.7276170037228 | -122.393920294208 | (37.7276170037228, -122.393920294208) | 10 | 3 | 8 | 58 | 1 | ||||
124548 | 243974 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 220 Coso Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5 | 6007544.45686 | 2099548.29836 | 37.7453861513651 | -122.416605743182 | (37.7453861513651, -122.416605743182) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
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 | ||||
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 | ||||
144992 | 253609 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 318 Utah St | 2 | Front Yard : Yard | Tree | Private 2 | Width 4ft | Permit Number 780845 | 6010580.39617 | 2106780.39752 | 37.7654141639451 | -122.406617457953 | (37.7654141639451, -122.406617457953) | 8 | 4 | 8 | 28853 | 19 | |||
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 | ||||
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 | ||||
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 | ||||
154704 | 199596 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1700 22nd St | 4 | Front Yard : Yard | Tree | Private 2 | 5 | 6012934.13528 | 2103807.83059 | 37.7573835553253 | -122.398267784253 | (37.7573835553253, -122.398267784253) | 10 | 3 | 8 | 28856 | 29 | ||||
156896 | 243982 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 200 Kingston St | 16 | Front Yard : Yard | Tree | Private 2 | 3 | 6006211.87378 | 2098086.29455 | 37.741296782931 | -122.421109815985 | (37.741296782931, -122.421109815985) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
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 | ||||
174970 | 217493 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 15th Ave | 3 | Front Yard : Yard | Tree | Private 2 | 24 | 5991534.00074 | 2105121.21234 | 37.7597744749213 | -122.472372960446 | (37.7597744749213, -122.472372960446) | 1 | 8 | 4 | 56 | 12 | ||||
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 | ||||
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 | |||
187155 | 247590 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 800 Tompkins Ave | 11 | Front Yard : Yard | Tree | Private 2 | 40 | 6008957.64855 | 2096444.89116 | 37.7369442521782 | -122.411499920492 | (37.7369442521782, -122.411499920492) | 10 | 7 | 7 | 28859 | 2 | ||||
4125 | 217527 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 22 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5996233.42463 | 2089002.36528 | 37.7157869222112 | -122.454955363219 | (37.7157869222112, -122.454955363219) | 9 | 8 | 6 | 28861 | 24 | |||
22048 | 217531 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 38 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5996362.99834 | 2088995.98421 | 37.7157768335986 | -122.454507038583 | (37.7157768335986, -122.454507038583) | 9 | 8 | 6 | 28861 | 24 | |||
53732 | 199599 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1510x 22nd St | 2 | Median : Cutout | Tree | DPW 1 | 9 | Width 6ft | 6013497.50922 | 2103827.38808 | 37.7574686213053 | -122.396320770893 | (37.7574686213053, -122.396320770893) | 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 | |||
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 | |||
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 | |||
107922 | 217528 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 23 | Median : Cutout | Tree | DPW 1 | 21 | Width 0ft | 5996239.67179 | 2089002.51742 | 37.7157876983267 | -122.454933781265 | (37.7157876983267, -122.454933781265) | 9 | 8 | 6 | 28861 | 24 | |||
114317 | 217530 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 28 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 5996285.62534 | 2089001.27472 | 37.7157869222129 | -122.454774855787 | (37.7157869222129, -122.454774855787) | 9 | 8 | 6 | 28861 | 24 | |||
134587 | 8465 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1900 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 48 | 8 | 6002373.3675 | 2113709.4137 | 37.7839769368091 | -122.435499366282 | (37.7839769368091, -122.435499366282) | 13 | 5 | 11 | 29490 | 41 | |||
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 | |||
175215 | 217529 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 24 | Median : Cutout | Tree | DPW 1 | 24 | Width 0ft | 5996247.03619 | 2089001.79824 | 37.7157861460877 | -122.454908274716 | (37.7157861460877, -122.454908274716) | 9 | 8 | 6 | 28861 | 24 | |||
77316 | 199614 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1700x Quesada Ave | 53 | Median : Yard | Tree | DPW 1 | 16 | 6014257.65945 | 2095401.98638 | 37.7343765087595 | -122.393102330216 | (37.7343765087595, -122.393102330216) | 10 | 3 | 8 | 58 | 1 | ||||
86416 | 199615 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1700x Quesada Ave | 56 | Median : Yard | Tree | DPW 1 | 20 | 6014226.56708 | 2095397.27479 | 37.7343618444247 | -122.393209497917 | (37.7343618444247, -122.393209497917) | 10 | 3 | 8 | 58 | 1 | ||||
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 | ||||
121007 | 250140 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2550x Lyon St | 8 | Median : Yard | Tree | DPW 1 | 15 | 5999207.82154 | 2117620.05733 | 37.7945342406205 | -122.446732429154 | (37.7945342406205, -122.446732429154) | 13 | 1 | 57 | 30 | |||||
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 | ||||
64145 | 199616 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1999 Revere Ave | 7 | Side Yard : Yard | Tree | Private 2 | 3 | 6013002.21254 | 2095907.198 | 37.7356938932469 | -122.397478268519 | (37.7356938932469, -122.397478268519) | 10 | 3 | 8 | 58 | 1 | ||||
89610 | 199620 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2399 Lane St | 6 | Side Yard : Yard | Tree | Private 2 | 7 | 6013988.45481 | 2092875.57425 | 37.7274245370974 | -122.393856279557 | (37.7274245370974, -122.393856279557) | 10 | 3 | 8 | 58 | 1 | ||||
97857 | 199618 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2399 Lane St | 4 | Side Yard : Yard | Tree | Private 2 | 9 | 6013981.31336 | 2092866.65416 | 37.7273996474538 | -122.393880343621 | (37.7273996474538, -122.393880343621) | 10 | 3 | 8 | 58 | 1 | ||||
108866 | 181293 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 184 Mount Vernon Ave | 1 | Side Yard : Yard | Tree | Private 2 | 25 | 5998992.13606 | 2089349.93081 | 37.7168991290824 | -122.44544499659 | (37.7168991290824, -122.44544499659) | 9 | 7 | 6 | 28861 | 25 | ||||
109382 | 246640 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3350 Harrison St | 1 | Side Yard : Yard | Tree | Private 2 | 12 | 6009029.3215 | 2099227.55373 | 37.744588855582 | -122.411448646563 | (37.744588855582, -122.411448646563) | 2 | 7 | 7 | 28859 | 2 | ||||
110609 | 246641 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3350 Harrison St | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 6009029.72026 | 2099218.69445 | 37.744564552317 | -122.411446641953 | (37.744564552317, -122.411446641953) | 2 | 7 | 7 | 28859 | 2 | ||||
186956 | 199619 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2399 Lane St | 5 | Side Yard : Yard | Tree | Private 2 | 22 | 6013984.3244 | 2092869.9258 | 37.7274087980523 | -122.393870163286 | (37.7274087980523, -122.393870163286) | 10 | 3 | 8 | 58 | 1 | ||||
189662 | 246642 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3350 Harrison St | 3 | Side Yard : Yard | Tree | Private 2 | 11 | 6009030.51293 | 2099210.21196 | 37.7445413057285 | -122.411443301892 | (37.7445413057285, -122.411443301892) | 2 | 7 | 7 | 28859 | 2 | ||||
1584 | 79997 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 8250 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5981344.9471 | 2112403.21249 | 37.7791737487824 | -122.508151741605 | (37.7791737487824, -122.508151741605) | 11 | 6 | 2 | 55 | 26 | |||
3638 | 72610 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 25th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6014116.81236 | 2101967.79317 | 37.7523970151345 | -122.394048777632 | (37.7523970151345, -122.394048777632) | 10 | 3 | 8 | 28856 | 1 | |||
3852 | 243986 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 922 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6008569.40583 | 2103127.50468 | 37.7552714408323 | -122.413314689443 | (37.7552714408323, -122.413314689443) | 2 | 4 | 7 | 28859 | 19 | |||
5110 | 79998 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 8250 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5981347.81694 | 2112377.495 | 37.7791033052806 | -122.508139904514 | (37.7791033052806, -122.508139904514) | 11 | 6 | 2 | 55 | 26 | |||
5902 | 98813 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 290 Napoleon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 3x3 | 6011920.40954 | 2099763.49202 | 37.7462221629395 | -122.401489439087 | (37.7462221629395, -122.401489439087) | 10 | 3 | 8 | 58 | 1 | |||
6788 | 89559 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 5227 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982413.61439 | 2111658.5087 | 37.7771919254702 | -122.504399660112 | (37.7771919254702, -122.504399660112) | 11 | 6 | 2 | 55 | 26 | ||
6982 | 72625 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 25th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014103.8148 | 2101960.56144 | 37.7523764359486 | -122.394093219441 | (37.7523764359486, -122.394093219441) | 10 | 3 | 8 | 28856 | 1 | |||
7251 | 78261 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 414 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 50 | 6009735.35322 | 2092462.55281 | 37.7260531896995 | -122.408530204426 | (37.7260531896995, -122.408530204426) | 10 | 3 | 7 | 309 | 28 | |||
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 |
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) );