trees
348 rows where Police Districts = 4 and qSpecies_id = 8 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1153 | 223389 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
1161 | 223387 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
1507 | 74233 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2400 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6010292.05063 | 2106000.69739 | 37.7632571481177 | -122.407559806245 | (37.7632571481177, -122.407559806245) | 8 | 4 | 8 | 28859 | 19 | |||
2303 | 223507 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006548.17508 | 2102589.95451 | 37.7536817641104 | -122.420266570244 | (37.7536817641104, -122.420266570244) | 2 | 4 | 7 | 28859 | 19 | |||
2337 | 223401 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3647 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6005476.77928 | 2102530.01598 | 37.7534567573481 | -122.423967438743 | (37.7534567573481, -122.423967438743) | 2 | 4 | 5 | 28859 | 19 | |||
2915 | 223666 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1511 Castro St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/16/2016 05:50:00 AM | 2 | Width 3ft | 6002610.0457 | 2101075.27233 | 37.7493001124297 | -122.433777236447 | (37.7493001124297, -122.433777236447) | 2 | 4 | 5 | 28862 | 22 | ||
3440 | 223611 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 255 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006745.90219 | 2102323.75764 | 37.752961988114 | -122.419563899379 | (37.752961988114, -122.419563899379) | 2 | 4 | 7 | 28859 | 19 | |||
3889 | 223641 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006696.02527 | 2102542.97279 | 37.753561093073 | -122.419751936808 | (37.753561093073, -122.419751936808) | 2 | 4 | 7 | 28859 | 19 | |||
7729 | 223606 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 552 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007244.98796 | 2104086.07115 | 37.7578289967226 | -122.417962880381 | (37.7578289967226, -122.417962880381) | 2 | 4 | 7 | 28859 | 19 | |||
7811 | 10192 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1169 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/16/2016 04:46:00 AM | 3 | 3X3 | 6005805.59526 | 2102140.15786 | 37.7524048554241 | -122.422802617046 | (37.7524048554241, -122.422802617046) | 2 | 4 | 5 | 28859 | 19 | ||
8807 | 224036 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1511 Castro St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/2016 07:10:00 AM | 2 | Width 3ft | 6002606.66337 | 2101060.9954 | 37.7492607194187 | -122.433787912303 | (37.7492607194187, -122.433787912303) | 2 | 4 | 5 | 28862 | 22 | ||
8809 | 223493 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007980.72085 | 2102939.00638 | 37.7547207985381 | -122.415337199951 | (37.7547207985381, -122.415337199951) | 2 | 4 | 7 | 28859 | 19 | |||
8863 | 224037 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4136 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002973.28417 | 2101264.18156 | 37.7498394178669 | -122.432534643177 | (37.7498394178669, -122.432534643177) | 2 | 4 | 5 | 28862 | 22 | |||
10631 | 106353 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 3520X 26TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6006283 | 2100840 | 37.7488618444312 | -122.421059362487 | (37.7488618444312, -122.421059362487) | 2 | 4 | 5 | 28859 | 19 | |||
11823 | 223370 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99 Lapidge St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6006029.2284 | 2104988.85011 | 37.7602393183104 | -122.422231628499 | (37.7602393183104, -122.422231628499) | 2 | 4 | 5 | 28859 | 19 | |||
12094 | 223388 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
13425 | 223490 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008605.30011 | 2107940.39716 | 37.768488553924 | -122.41353093232 | (37.768488553924, -122.41353093232) | 8 | 4 | 7 | 28853 | 19 | |||
13899 | 223627 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 324 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006726 | 2101710 | 37.7512756289395 | -122.419589182986 | (37.7512756289395, -122.419589182986) | 2 | 4 | 7 | 28859 | 19 | |||
14213 | 74019 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2400 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 6010272.25282 | 2105997.87843 | 37.7632482996846 | -122.407628081878 | (37.7632482996846, -122.407628081878) | 8 | 4 | 8 | 28859 | 19 | ||
14883 | 242086 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4185 25th St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 02/16/2016 05:57:00 AM | 2 | Width 3ft | 6002948.22198 | 2101215.85126 | 37.7497052929799 | -122.432617857444 | (37.7497052929799, -122.432617857444) | 2 | 4 | 5 | 28862 | 22 | ||
15080 | 223395 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3641 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005336.13601 | 2104859.99107 | 37.7598463829262 | -122.424619544351 | (37.7598463829262, -122.424619544351) | 2 | 4 | 5 | 28859 | 19 | |||
15659 | 26852 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/19/2016 05:13:00 AM | 3 | 2X2 | 6005817.98305 | 2101925.96787 | 37.7518174380456 | -122.422744557734 | (37.7518174380456, -122.422744557734) | 2 | 4 | 5 | 28859 | 19 | ||
16530 | 223386 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3665 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005227.03743 | 2104855.48781 | 37.7598278559952 | -122.424996542879 | (37.7598278559952, -122.424996542879) | 2 | 4 | 5 | 28859 | 19 | |||
18129 | 223629 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006717.33389 | 2102164.58545 | 37.7525233285091 | -122.419651401605 | (37.7525233285091, -122.419651401605) | 2 | 4 | 7 | 28859 | 19 | |||
18151 | 72422 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2400 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 6010224.23312 | 2105998.24791 | 37.7632466260627 | -122.407794192953 | (37.7632466260627, -122.407794192953) | 8 | 4 | 8 | 28859 | 19 | ||
18943 | 166174 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3356 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6006632.30883 | 2102638.63296 | 37.7538201643798 | -122.419979070489 | (37.7538201643798, -122.419979070489) | 2 | 4 | 7 | 28859 | 19 | |||
19933 | 223498 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 255 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006745.96401 | 2102320.90162 | 37.7529541496195 | -122.41956348298 | (37.7529541496195, -122.41956348298) | 2 | 4 | 7 | 28859 | 19 | |||
21102 | 223642 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006690.61182 | 2102567.74424 | 37.753628804832 | -122.419772415291 | (37.753628804832, -122.419772415291) | 2 | 4 | 7 | 28859 | 19 | |||
21897 | 223405 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 201 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005449.32896 | 2102471.93612 | 37.7532957337303 | -122.424058237901 | (37.7532957337303, -122.424058237901) | 2 | 4 | 5 | 28859 | 19 | |||
22090 | 224049 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 260 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002051.64145 | 2104349.66378 | 37.7582591055966 | -122.435942470278 | (37.7582591055966, -122.435942470278) | 2 | 4 | 5 | 28862 | 3 | |||
22315 | 113814 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 02/16/2016 06:05:00 AM | 3 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
23459 | 223514 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3349 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006548.63349 | 2106093.81796 | 37.763302585471 | -122.420513683285 | (37.763302585471, -122.420513683285) | 8 | 4 | 7 | 28859 | 19 | |||
24237 | 223512 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007094.15413 | 2105540.45939 | 37.7618139197035 | -122.418587660093 | (37.7618139197035, -122.418587660093) | 2 | 4 | 7 | 28859 | 19 | |||
25072 | 223529 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4175 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002046.64832 | 2102339.03335 | 37.7527381135931 | -122.435815881724 | (37.7527381135931, -122.435815881724) | 2 | 4 | 5 | 28862 | 22 | |||
25347 | 98970 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6008234.2 | 2102998.9 | 37.7548994960031 | -122.414464835105 | (37.7548994960031, -122.414464835105) | 2 | 4 | 7 | 28859 | 19 | ||
28415 | 223396 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 90 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6006003.81464 | 2104993.73555 | 37.7602512990686 | -122.42231986997 | (37.7602512990686, -122.42231986997) | 2 | 4 | 5 | 28859 | 19 | |||
29054 | 223592 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1142 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009191.70637 | 2102498.92995 | 37.7535804348003 | -122.411118182576 | (37.7535804348003, -122.411118182576) | 2 | 4 | 7 | 28859 | 19 | |||
29160 | 223644 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3266 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008388.34903 | 2104490.30808 | 37.759003221729 | -122.414037245221 | (37.759003221729, -122.414037245221) | 2 | 4 | 7 | 28859 | 19 | |||
29275 | 257895 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3644 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | ||||
30436 | 223435 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 335 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006142.1002 | 2107638.15055 | 37.7675200389439 | -122.422029465401 | (37.7675200389439, -122.422029465401) | 8 | 4 | 7 | 28853 | 19 | |||
30646 | 223609 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3330 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006825.79297 | 2102649.13813 | 37.7538599081198 | -122.419310701547 | (37.7538599081198, -122.419310701547) | 2 | 4 | 7 | 28859 | 19 | |||
31318 | 223620 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 439 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006808.42719 | 2101225.05572 | 37.7499487250622 | -122.419269742819 | (37.7499487250622, -122.419269742819) | 2 | 4 | 7 | 28859 | 19 | |||
32151 | 22922 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6006142.65939 | 2107729.77965 | 37.7677716622264 | -122.422034041273 | (37.7677716622264, -122.422034041273) | 8 | 4 | 7 | 28853 | 19 | |||
34878 | 224062 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 67 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004498.44679 | 2107387.20492 | 37.7667381638479 | -122.427696765417 | (37.7667381638479, -122.427696765417) | 8 | 4 | 5 | 28862 | 3 | |||
35182 | 224055 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3810 20th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6004350.69854 | 2104285.65184 | 37.7582136808258 | -122.427986763479 | (37.7582136808258, -122.427986763479) | 2 | 4 | 5 | 28862 | 3 | |||
35960 | 99029 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
36383 | 223525 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4126 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6002321.16912 | 2101815.04035 | 37.7513149436309 | -122.434829071802 | (37.7513149436309, -122.434829071802) | 2 | 4 | 5 | 28862 | 22 | |||
38908 | 223615 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 408 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006795.31694 | 2101399.56356 | 37.7504271455035 | -122.419327456816 | (37.7504271455035, -122.419327456816) | 2 | 4 | 7 | 28859 | 19 | |||
39001 | 99032 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
39142 | 223599 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6007767.1377 | 2106084.40018 | 37.7633453203425 | -122.416298598605 | (37.7633453203425, -122.416298598605) | 8 | 4 | 7 | 28859 | 19 | |||
39376 | 223432 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 321 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6006137.48741 | 2107733.43659 | 37.7677814116141 | -122.422052190377 | (37.7677814116141, -122.422052190377) | 8 | 4 | 7 | 28853 | 19 | |||
39722 | 223593 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 930 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009378.63549 | 2103724.24958 | 37.756955368323 | -122.41055825836 | (37.756955368323, -122.41055825836) | 2 | 4 | 7 | 28859 | 19 | |||
39751 | 96590 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
40081 | 223634 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bartlett St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006707.09054 | 2102321.33719 | 37.7529531558696 | -122.419697945997 | (37.7529531558696, -122.419697945997) | 2 | 4 | 7 | 28859 | 19 | |||
40964 | 99037 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
42503 | 229348 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2970 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6009679.24982 | 2101052.76499 | 37.7496369166219 | -122.409330094713 | (37.7496369166219, -122.409330094713) | 2 | 4 | 7 | 28859 | 19 | |||
42828 | 223602 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 280x Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2017 12:00:00 AM | 3 | Width 3ft | 6007724 | 2106220 | 37.7637152201621 | -122.416457403809 | (37.7637152201621, -122.416457403809) | 8 | 4 | 7 | 28859 | 19 | ||
42971 | 103367 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 290X Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6006718.6 | 2102097 | 37.7523378256517 | -122.419642228322 | (37.7523378256517, -122.419642228322) | 2 | 4 | 7 | 28859 | 19 | |||
43583 | 223616 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 408 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006796.55753 | 2101381.3101 | 37.75037709553 | -122.419321872018 | (37.75037709553, -122.419321872018) | 2 | 4 | 7 | 28859 | 19 | |||
43767 | 223603 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 66 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007689.4598 | 2107580.51877 | 37.7674489448444 | -122.416673255272 | (37.7674489448444, -122.416673255272) | 8 | 4 | 7 | 28853 | 19 | |||
44908 | 96593 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
45663 | 223608 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3336 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006799.35896 | 2102646.46368 | 37.7538510758905 | -122.419401926961 | (37.7538510758905, -122.419401926961) | 2 | 4 | 7 | 28859 | 19 | |||
46230 | 99035 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
46659 | 223403 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3624 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005621.17135 | 2101994.19422 | 37.7519936655859 | -122.423430010205 | (37.7519936655859, -122.423430010205) | 2 | 4 | 5 | 28859 | 19 | |||
47083 | 224046 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 208 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5999979.04483 | 2104876.63266 | 37.7595880742544 | -122.443148238699 | (37.7595880742544, -122.443148238699) | 2 | 4 | 5 | 28862 | 3 | |||
48313 | 223502 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3433 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006860.5286 | 2101435.19922 | 37.7505286654636 | -122.419104477086 | (37.7505286654636, -122.419104477086) | 2 | 4 | 7 | 28859 | 19 | |||
51446 | 223363 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2676 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009986.00474 | 2103992.15144 | 37.757724999121 | -122.40847663451 | (37.757724999121, -122.40847663451) | 2 | 4 | 7 | 28859 | 19 | |||
52398 | 223365 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1451 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6010379.01275 | 2101132.73007 | 37.7498956641741 | -122.406915913261 | (37.7498956641741, -122.406915913261) | 10 | 4 | 7 | 28859 | 19 | |||
54683 | 223522 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 811 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001294.89764 | 2099975.47242 | 37.7462056082153 | -122.438246257254 | (37.7462056082153, -122.438246257254) | 2 | 4 | 5 | 63 | 22 | |||
54927 | 223447 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1261 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003898.74209 | 2100909.80549 | 37.7489188214426 | -122.429309101453 | (37.7489188214426, -122.429309101453) | 2 | 4 | 5 | 28862 | 22 | |||
55160 | 108690 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 61 OAKWOOD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005327.5 | 2105108.8 | 37.7605290659119 | -122.424667111807 | (37.7605290659119, -122.424667111807) | 2 | 4 | 5 | 28859 | 19 | ||||
57602 | 223527 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 647 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002187.40945 | 2102635.29602 | 37.7535595750195 | -122.435350295491 | (37.7535595750195, -122.435350295491) | 2 | 4 | 5 | 28862 | 22 | |||
58531 | 223496 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007971.83825 | 2103118.56148 | 37.7552133167577 | -122.415380629129 | (37.7552133167577, -122.415380629129) | 2 | 4 | 7 | 28859 | 19 | |||
59728 | 223664 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 730 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001679.46689 | 2102069.69668 | 37.7519777151979 | -122.437066377309 | (37.7519777151979, -122.437066377309) | 2 | 4 | 5 | 28862 | 22 | |||
60680 | 223433 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 321 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006139.56315 | 2107708.41808 | 37.7677128338021 | -122.422043233108 | (37.7677128338021, -122.422043233108) | 8 | 4 | 7 | 28853 | 19 | |||
60745 | 223399 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3438 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005409.07211 | 2103737.92814 | 37.7567695800561 | -122.424287488577 | (37.7567695800561, -122.424287488577) | 2 | 4 | 5 | 28859 | 19 | |||
62996 | 99030 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
63210 | 96591 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
63331 | 223637 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bartlett St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006705.76334 | 2102387.84087 | 37.7531356849695 | -122.419707254007 | (37.7531356849695, -122.419707254007) | 2 | 4 | 7 | 28859 | 19 | |||
63646 | 223379 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2730 22nd St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 7ft | 6009758.65341 | 2103393.8455 | 37.7560694506528 | -122.4092206931 | (37.7560694506528, -122.4092206931) | 2 | 4 | 7 | 28859 | 19 | |||
65134 | 223638 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006702.00783 | 2102414.72297 | 37.7532092854977 | -122.419722148578 | (37.7532092854977, -122.419722148578) | 2 | 4 | 7 | 28859 | 19 | |||
65825 | 223503 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3421 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006951.65327 | 2101439.66063 | 37.7505460466667 | -122.41878967662 | (37.7505460466667, -122.41878967662) | 2 | 4 | 7 | 28859 | 19 | |||
65936 | 223499 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 255 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6006746.2446 | 2102306.01848 | 37.752913299731 | -122.419561456798 | (37.752913299731, -122.419561456798) | 2 | 4 | 7 | 28859 | 19 | |||
66136 | 99033 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
67765 | 223367 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3450 26th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006755.66784 | 2100887.58392 | 37.7490191327351 | -122.419428249231 | (37.7490191327351, -122.419428249231) | 2 | 4 | 7 | 28859 | 19 | |||
69745 | 223394 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 29 Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005256.12895 | 2105270.01288 | 37.76096768734 | -122.424925421792 | (37.76096768734, -122.424925421792) | 2 | 4 | 5 | 28859 | 19 | |||
73153 | 96487 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 255 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006742 | 2102298 | 37.7528910437328 | -122.419575566599 | (37.7528910437328, -122.419575566599) | 2 | 4 | 7 | 28859 | 19 | |||
73169 | 223619 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 429 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006801.93738 | 2101276.12036 | 37.7500885714431 | -122.419295806956 | (37.7500885714431, -122.419295806956) | 2 | 4 | 7 | 28859 | 19 | |||
73679 | 224048 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 395 Diamond St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001818.32693 | 2103639.30032 | 37.7562953621538 | -122.436698524039 | (37.7562953621538, -122.436698524039) | 2 | 4 | 5 | 28862 | 3 | |||
74102 | 223636 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bartlett St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006708.59634 | 2102368.48305 | 37.7530826924205 | -122.419696083521 | (37.7530826924205, -122.419696083521) | 2 | 4 | 7 | 28859 | 19 | |||
75331 | 224051 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3866 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002622.24205 | 2103582.54742 | 37.7561851862111 | -122.433914254443 | (37.7561851862111, -122.433914254443) | 2 | 4 | 5 | 28862 | 3 | |||
79010 | 223385 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3667 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005189.30238 | 2104853.5381 | 37.7598203709419 | -122.4251269113 | (37.7598203709419, -122.4251269113) | 2 | 4 | 5 | 28859 | 19 | |||
81530 | 96594 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
83305 | 223364 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1451 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010383.8577 | 2101121.66239 | 37.7498655458655 | -122.406898379155 | (37.7498655458655, -122.406898379155) | 10 | 4 | 7 | 28859 | 19 | |||
83317 | 223613 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 269 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006752.54464 | 2102227.65938 | 37.7526984984487 | -122.419534111127 | (37.7526984984487, -122.419534111127) | 2 | 4 | 7 | 28859 | 19 | |||
83576 | 223511 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3453 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6006534.0585 | 2105513.36984 | 37.7617079894668 | -122.42052288872 | (37.7617079894668, -122.42052288872) | 2 | 4 | 7 | 28859 | 19 | |||
83988 | 224045 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 118 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6000330.71148 | 2104908.09647 | 37.7596945117222 | -122.441934261878 | (37.7596945117222, -122.441934261878) | 2 | 4 | 5 | 28862 | 3 | |||
85068 | 223635 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bartlett St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006712.94406 | 2102318.00043 | 37.7529443236272 | -122.41967746664 | (37.7529443236272, -122.41967746664) | 2 | 4 | 7 | 28859 | 19 | |||
86041 | 224052 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 259 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004554.98414 | 2103937.91875 | 37.7572704430872 | -122.427255485157 | (37.7572704430872, -122.427255485157) | 2 | 4 | 5 | 28862 | 3 | |||
86104 | 223371 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3527 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6006033.70926 | 2105484.59441 | 37.7616007686849 | -122.422251353329 | (37.7616007686849, -122.422251353329) | 2 | 4 | 5 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );