trees
7,322 rows where qSpecies_id = 1 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
90 | 259864 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1398x Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | |||||||||||||
1095 | 255202 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
1138 | 260594 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
2475 | 259866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
4112 | 255223 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1051 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
6640 | 255204 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
6981 | 259867 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
7570 | 36838 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
7587 | 259089 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
7844 | 36854 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
8196 | 255225 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 400 Bacon St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
8832 | 260593 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
10581 | 260591 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
11185 | 98268 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
11245 | 255201 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
11633 | 259865 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
11767 | 255200 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
12758 | 260592 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
13636 | 36840 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
13881 | 255222 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1051 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
14357 | 36839 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
14394 | 36837 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
15903 | 255203 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
18459 | 36836 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
1267 | 244161 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 441 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004421.3191 | 2109776.7375 | 37.7732948782123 | -122.428133844936 | (37.7732948782123, -122.428133844936) | 7 | 9 | 11 | 28852 | 10 | |||
1557 | 33639 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 440 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 5 | Permit Number 37734 | 6005272.3664 | 2110799.1387 | 37.7761502580876 | -122.425262720434 | (37.7761502580876, -122.425262720434) | 7 | 9 | 11 | 28852 | 10 | |
2643 | 112356 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 333 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6009373.44227 | 2114078.66133 | 37.7853858834919 | -122.411307667026 | (37.7853858834919, -122.411307667026) | 14 | 10 | 9 | 28852 | 36 | |||
3422 | 136854 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 685 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008467.44267 | 2114497.67483 | 37.7864855385225 | -122.414471823731 | (37.7864855385225, -122.414471823731) | 5 | 1 | 9 | 28852 | 36 | |||
4368 | 262109 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 340 Oak St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6005374.8248 | 2110307.1287 | 37.7748051060186 | -122.424873276976 | (37.7748051060186, -122.424873276976) | 7 | 9 | 11 | 28852 | 10 | ||||
4712 | 39418 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
4714 | 138839 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 680 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004061.0808 | 2111069.2221 | 37.7768233350725 | -122.429472148942 | (37.7768233350725, -122.429472148942) | 7 | 9 | 11 | 28852 | 10 | |||
4886 | 141434 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 511 HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6005350.2266 | 2110949.2548 | 37.7765668387099 | -122.425004063889 | (37.7765668387099, -122.425004063889) | 7 | 9 | 11 | 28852 | 10 | |||
5298 | 16892 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 311 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/05/2011 12:00:00 AM | 6 | 3X3 | 6005385.8444 | 2110257.3545 | 37.7746690605587 | -122.424831616025 | (37.7746690605587, -122.424831616025) | 7 | 9 | 11 | 28852 | 10 | ||
6672 | 39412 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
7279 | 12251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 512 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/24/2014 12:00:00 AM | 3 | 3X3 | 6005037.9059 | 2110678.2828 | 37.77580516874 | -122.426065177531 | (37.77580516874, -122.426065177531) | 7 | 9 | 11 | 28852 | 10 | ||
9383 | 245841 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 340 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6005374.8248 | 2110307.1287 | 37.7748051060186 | -122.424873276976 | (37.7748051060186, -122.424873276976) | 7 | 9 | 11 | 28852 | 10 | |||
10070 | 7833 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 880 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 6006176.68475 | 2113023.80022 | 37.7823096849858 | -122.42229253147 | (37.7823096849858, -122.42229253147) | 7 | 9 | 11 | 28852 | 41 | |||
12582 | 32159 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
13356 | 248669 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 477 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/2018 12:00:00 AM | 3 | 2x | 6004700.21888 | 2110347.50884 | 37.7748778530593 | -122.427209756419 | (37.7748778530593, -122.427209756419) | 7 | 9 | 11 | 28852 | 10 | ||
13447 | 6878 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 250 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/28/1994 12:00:00 AM | 6 | 3X3 | 6006200.5661 | 2110766.80377 | 37.7761138687045 | -122.422049524766 | (37.7761138687045, -122.422049524766) | 7 | 9 | 11 | 28852 | 10 | ||
14740 | 248670 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 477 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/2018 12:00:00 AM | 3 | Width 2ft | 6004723.7133 | 2110351.25176 | 37.7748894588255 | -122.427128750898 | (37.7748894588255, -122.427128750898) | 7 | 9 | 11 | 28852 | 10 | ||
15925 | 244208 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 417 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004573.463 | 2109795.1498 | 37.7733540408522 | -122.42760887026 | (37.7733540408522, -122.42760887026) | 7 | 9 | 11 | 28852 | 10 | |||
17719 | 244155 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 465 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004291.9483 | 2109759.7787 | 37.7732409929902 | -122.428580147189 | (37.7732409929902, -122.428580147189) | 7 | 9 | 11 | 28852 | 10 | |||
20618 | 244139 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 441 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004334.8503 | 2109600.9194 | 37.7728072319255 | -122.42842041843 | (37.7728072319255, -122.42842041843) | 7 | 9 | 11 | 28852 | 10 | |||
21043 | 140012 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 830 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2018 02:43:00 PM | 3 | Width 0ft | 6004895.2399 | 2111747.232 | 37.7787321771615 | -122.426634832347 | (37.7787321771615, -122.426634832347) | 7 | 9 | 11 | 28852 | 41 | ||
22929 | 136865 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 750 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006308.5123 | 2112860.73674 | 37.7818693876916 | -122.42182487954 | (37.7818693876916, -122.42182487954) | 7 | 9 | 11 | 28852 | 41 | |||
24407 | 136791 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 544 Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004692.56691 | 2110718.60758 | 37.7758963667591 | -122.42726266626 | (37.7758963667591, -122.42726266626) | 7 | 9 | 11 | 28852 | 10 | |||
24734 | 136867 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2014 12:00:00 AM | 7 | Width 4ft | Permit Number 773338 | 6006067.02029 | 2112827.44756 | 37.7817643621779 | -122.42265796469 | (37.7817643621779, -122.42265796469) | 7 | 9 | 11 | 28852 | 41 | |
26039 | 138837 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 666 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004066.4292 | 2111036.129 | 37.7767327723898 | -122.42945128666 | (37.7767327723898, -122.42945128666) | 7 | 9 | 11 | 28852 | 10 | |||
27088 | 241742 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 316 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 2ft | 6004696.52365 | 2109682.80087 | 37.7730525179915 | -122.427175182016 | (37.7730525179915, -122.427175182016) | 7 | 9 | 11 | 28852 | 10 | |||
27871 | 16911 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 465 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2012 12:00:00 AM | 3 | 3x3 | 6004752.04219 | 2110164.02671 | 37.7743769864453 | -122.427017417525 | (37.7743769864453, -122.427017417525) | 7 | 9 | 11 | 28852 | 10 | ||
29161 | 24487 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 618 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1995 12:00:00 AM | 3 | 3X3 | 6004392.5811 | 2110517.0483 | 37.7753259646513 | -122.428286026192 | (37.7753259646513, -122.428286026192) | 7 | 9 | 11 | 28852 | 10 | ||
31056 | 7830 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 828 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 6006192.27553 | 2112919.76373 | 37.7820249056667 | -122.422231200417 | (37.7820249056667, -122.422231200417) | 7 | 9 | 11 | 28852 | 41 | |||
31278 | 41441 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 280 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 42042 | 6006154.15968 | 2110763.0848 | 37.7761010398668 | -122.422209792973 | (37.7761010398668, -122.422209792973) | 7 | 9 | 11 | 28852 | 10 | |
31898 | 244158 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 453 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004360.7522 | 2109769.4694 | 37.7732714947927 | -122.428342836041 | (37.7732714947927, -122.428342836041) | 7 | 9 | 11 | 28852 | 10 | |||
32166 | 246604 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Waller St | 6 | : | Tree | Private 2 | 1 | Width 4ft | 6005614.48903 | 2109249.34773 | 37.7719142289884 | -122.423968991887 | (37.7719142289884, -122.423968991887) | 7 | 9 | 5 | 28852 | 10 | |||
34357 | 142252 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 461 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005174.8759 | 2110761.2705 | 37.7760407730755 | -122.425597270874 | (37.7760407730755, -122.425597270874) | 7 | 9 | 11 | 28852 | 10 | |||
35499 | 241644 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 415 Oak St | 1 | : | Tree | Private 2 | 5 | Width 5ft | 6004982.83626 | 2110199.46219 | 37.7744873314449 | -122.426221580476 | (37.7744873314449, -122.426221580476) | 7 | 9 | 11 | 28852 | 10 | |||
35764 | 22600 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 837 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005887.44223 | 2112751.69518 | 37.7815462316211 | -122.42327383484 | (37.7815462316211, -122.42327383484) | 7 | 9 | 11 | 28852 | 41 | |||
36237 | 22616 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1001 Turk St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005581.297 | 2112717.6262 | 37.7814354041528 | -122.424330527926 | (37.7814354041528, -122.424330527926) | 7 | 9 | 11 | 28852 | 41 | |||
36412 | 142270 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 522 FELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004888.0208 | 2110591.8336 | 37.7755593279808 | -122.426577511169 | (37.7755593279808, -122.426577511169) | 7 | 9 | 11 | 28852 | 10 | |||
37498 | 12286 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/2014 12:00:00 AM | 3 | 4X4 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | 7 | 9 | 11 | 28852 | 41 | ||
39914 | 136870 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 811 Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006071.17664 | 2112778.07813 | 37.781629040298 | -122.422640076283 | (37.781629040298, -122.422640076283) | 7 | 9 | 11 | 28852 | 41 | |||
40948 | 51847 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 138 Cyril Magnin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 3x3 | Permit Number 48071 | 6010188.39401853 | 2113860.37409529 | 37.7848321915742 | -122.408472762748 | (37.7848321915742, -122.408472762748) | 14 | 10 | 10 | 28852 | 36 | ||
41193 | 16883 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
41572 | 92781 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52997 | 6006262 | 2110430 | 37.775192551515 | -122.421813078941 | (37.775192551515, -122.421813078941) | 7 | 9 | 11 | 28852 | 10 | |
43902 | 136860 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 887 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006214.69368 | 2113148.06645 | 37.7826530335388 | -122.422169868442 | (37.7826530335388, -122.422169868442) | 7 | 9 | 11 | 28852 | 41 | |||
44072 | 241749 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 222 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004214.19221 | 2109623.58112 | 37.7728626270278 | -122.428839404422 | (37.7728626270278, -122.428839404422) | 7 | 9 | 11 | 28852 | 10 | |||
44668 | 136790 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 544 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004708.98958 | 2110721.14604 | 37.7759042654909 | -122.427206036843 | (37.7759042654909, -122.427206036843) | 7 | 9 | 11 | 28852 | 10 | |||
45529 | 244141 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 433 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004381.5624 | 2109605.533 | 37.7728225429448 | -122.428259164791 | (37.7728225429448, -122.428259164791) | 7 | 9 | 11 | 28852 | 10 | |||
46288 | 136874 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 280 Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006040.06408 | 2110747.32522 | 37.7760513316506 | -122.422603360582 | (37.7760513316506, -122.422603360582) | 7 | 9 | 11 | 28852 | 10 | |||
47945 | 16888 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
48586 | 16880 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
48993 | 52138 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 599X BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2005 12:00:00 AM | 2 | 4x24 | Permit Number 48318 | 6004543 | 2110488 | 37.7752547151739 | -122.427763622088 | (37.7752547151739, -122.427763622088) | 7 | 9 | 11 | 28852 | 10 | |
49674 | 241748 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 222 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004212.10599 | 2109643.02481 | 37.7729158965736 | -122.428848007327 | (37.7729158965736, -122.428848007327) | 7 | 9 | 11 | 28852 | 10 | |||
49682 | 112303 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25x WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005453 | 2109246 | 37.7718959184753 | -122.424527356528 | (37.7718959184753, -122.424527356528) | 7 | 9 | 5 | 28852 | 10 | ||||
49987 | 7831 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 828 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 6006187.42417 | 2112935.31044 | 37.7820673194837 | -122.42224908883 | (37.7820673194837, -122.42224908883) | 7 | 9 | 11 | 28852 | 41 | |||
51164 | 6923 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 436 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6005320.8239 | 2110648.3853 | 37.7757390634098 | -122.425084363796 | (37.7757390634098, -122.425084363796) | 7 | 9 | 11 | 28852 | 10 | |||
52667 | 244444 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 430 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004319.0822 | 2109629.4389 | 37.7728846472297 | -122.428476995275 | (37.7728846472297, -122.428476995275) | 7 | 9 | 11 | 28852 | 10 | |||
52857 | 138838 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 676 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004063.4207 | 2111053.5112 | 37.7767803292934 | -122.429462933846 | (37.7767803292934, -122.429462933846) | 7 | 9 | 11 | 28852 | 10 | |||
53135 | 32162 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
53148 | 26874 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 129 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2000 12:00:00 AM | 6 | 3x3 | 6006373 | 2110396 | 37.7751054547407 | -122.4214266892 | (37.7751054547407, -122.4214266892) | 7 | 9 | 11 | 28852 | 10 | ||
57086 | 244382 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 243 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005794.6759 | 2110314.4219 | 37.7748488369521 | -122.423421441872 | (37.7748488369521, -122.423421441872) | 7 | 9 | 11 | 28852 | 10 | |||
57487 | 7835 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 880 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1994 12:00:00 AM | 6 | 4x4 | 6006172.94925 | 2113057.71328 | 37.7824025912343 | -122.422307864931 | (37.7824025912343, -122.422307864931) | 7 | 9 | 11 | 28852 | 41 | ||
58143 | 12288 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 830 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2016 09:27:00 AM | 3 | 4X4 | 6004888 | 2111612 | 37.7783604539947 | -122.426650245545 | (37.7783604539947, -122.426650245545) | 7 | 9 | 11 | 28852 | 41 | ||
58682 | 7828 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 828 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 6006198.01452 | 2112875.51126 | 37.7819037229178 | -122.422208201166 | (37.7819037229178, -122.422208201166) | 7 | 9 | 11 | 28852 | 41 | |||
61547 | 244437 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 406 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004585.5764 | 2109669.413 | 37.7730094833894 | -122.427558008617 | (37.7730094833894, -122.427558008617) | 7 | 9 | 11 | 28852 | 10 | |||
61679 | 33753 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 342 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1996 12:00:00 AM | 5 | Permit Number 37806 | 6006183.48634 | 2111105.86926 | 37.7770438971984 | -122.42213270218 | (37.7770438971984, -122.42213270218) | 7 | 9 | 11 | 28852 | 10 | ||
61770 | 244142 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 433 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004398.2864 | 2109609.5698 | 37.7728345732855 | -122.428201602292 | (37.7728345732855, -122.428201602292) | 7 | 9 | 11 | 28852 | 10 | |||
63311 | 244440 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 412 Rose St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004515.8034 | 2109656.8151 | 37.7729709458812 | -122.427798464303 | (37.7729709458812, -122.427798464303) | 7 | 9 | 11 | 28852 | 10 | |||
63709 | 109830 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 629 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009246.3 | 2115118.4 | 37.7882336239769 | -122.41182103906 | (37.7882336239769, -122.41182103906) | 5 | 1 | 10 | 28852 | 21 | |||||
64485 | 32164 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
64488 | 245864 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005410.1798 | 2109615.9511 | 37.7729092966004 | -122.424701797021 | (37.7729092966004, -122.424701797021) | 7 | 9 | 11 | 28852 | 10 | |||
64647 | 136868 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800 Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006044.82397 | 2112825.69674 | 37.7817583025558 | -122.422734629197 | (37.7817583025558, -122.422734629197) | 7 | 9 | 11 | 28852 | 41 | |||
65272 | 39411 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
65375 | 46592 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 255 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51875 | 6008348.96688497 | 2112748.91924615 | 37.7816772210699 | -122.414757915305 | (37.7816772210699, -122.414757915305) | 7 | 10 | 9 | 28852 | 36 | |
67199 | 244435 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 402 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004622.8856 | 2109675.7119 | 37.773028888846 | -122.427429400254 | (37.773028888846, -122.427429400254) | 7 | 9 | 11 | 28852 | 10 | |||
67380 | 138950 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 742 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004288.0524 | 2110846.9303 | 37.7762258245179 | -122.428671135937 | (37.7762258245179, -122.428671135937) | 7 | 9 | 11 | 28852 | 10 | |||
67726 | 136864 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 887 Eddy St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/09/2015 02:27:00 PM | 5 | Width 4ft | 6006291.78466 | 2113161.19437 | 37.7826934275133 | -122.421904099019 | (37.7826934275133, -122.421904099019) | 7 | 9 | 11 | 28852 | 41 | ||
68363 | 16887 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 |
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) );